﻿/********************************************************************************
     File:																
            DataProvider.cs                         
     Description:
            抽象数据操作类
     Author:									
            DDBuildTools
            http://FrameWork.supesoft.com
     Finish DateTime:
			2013/4/1 12:21:45
     History:
*********************************************************************************/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Collections;
using FrameWork.Components;
using Model.Components;

namespace Model.Data
{
    /// <summary>
    /// 委托将DataReader转为实体类
    /// </summary>
    /// <param name="dr">记录集</param>
    /// <param name="Fileds">字段名列表</param>
    /// <returns></returns>
    public delegate T PopulateDelegate<T>(IDataReader dr,Dictionary<string,string> Fileds);

    /// <summary>
    /// 数据抽象类
    /// </summary>
    public abstract partial class DataProvider
    {
        
        #region "DataProvider Instance"
        private static DataProvider _defaultInstance = null;
        static DataProvider()
        {
            DataProvider dataProvider;
            if (FrameWork.Common.GetDBType == "MsSql")
                dataProvider = new SqlDataProvider();
            
            else
                throw new ApplicationException("数据库配置不对！");
            _defaultInstance = dataProvider;
        }

        /// <summary>
        /// 数据访问抽象层实例
        /// </summary>
        /// <returns></returns>
        public static DataProvider Instance()
        {

            return _defaultInstance;
        }

        /// <summary>
        /// 数据访问抽象层实例
        /// </summary>
        /// <param name="strConn">数据库连接字符串</param>
        /// <returns></returns>
        public static DataProvider Instance(string strConn)
        {
            return new SqlDataProvider(strConn);
        }
        #endregion


        #region "T_TJ(T_TJ) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 T_TJEntity (T_TJ)
        /// </summary>
        /// <param name="fam">T_TJ实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 T_TJInsertUpdateDelete(T_TJEntity fam);

        /// <summary>
        /// 返回T_TJEntity实体类的List对象 (T_TJ)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>T_TJEntity实体类的List对象(T_TJ)</returns>
        public abstract List<T_TJEntity> T_TJList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为T_TJEntity实体类 (T_TJ)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>T_TJEntity</returns>
        protected T_TJEntity PopulateT_TJEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            T_TJEntity nc = new T_TJEntity();

            if (Fileds.ContainsKey("id") && !Convert.IsDBNull(dr["id"])) nc.id = Convert.ToInt32(dr["id"]); // 序号
            if (Fileds.ContainsKey("bldw") && !Convert.IsDBNull(dr["bldw"])) nc.bldw = Convert.ToInt32(dr["bldw"]); // 办理单位
            if (Fileds.ContainsKey("zjs") && !Convert.IsDBNull(dr["zjs"])) nc.zjs = Convert.ToDouble(dr["zjs"]); // 总件数
            if (Fileds.ContainsKey("asbj") && !Convert.IsDBNull(dr["asbj"])) nc.asbj = Convert.ToDouble(dr["asbj"]); // 按时办结数
            if (Fileds.ContainsKey("zbj") && !Convert.IsDBNull(dr["zbj"])) nc.zbj = Convert.ToDouble(dr["zbj"]); // 总办结数
            if (Fileds.ContainsKey("asbjl") && !Convert.IsDBNull(dr["asbjl"])) nc.asbjl = Convert.ToDouble(dr["asbjl"]); // 按时办结率
            if (Fileds.ContainsKey("zbjl") && !Convert.IsDBNull(dr["zbjl"])) nc.zbjl = Convert.ToDouble(dr["zbjl"]); // 总办结率
            return nc;
        }
        #endregion
        
        #region "LFSea(来访季报表) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 LFSeaEntity (来访季报表)
        /// </summary>
        /// <param name="fam">LFSea实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 LFSeaInsertUpdateDelete(LFSeaEntity fam);

        /// <summary>
        /// 返回LFSeaEntity实体类的List对象 (来访季报表)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>LFSeaEntity实体类的List对象(来访季报表)</returns>
        public abstract List<LFSeaEntity> LFSeaList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为LFSeaEntity实体类 (来访季报表)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>LFSeaEntity</returns>
        protected LFSeaEntity PopulateLFSeaEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            LFSeaEntity nc = new LFSeaEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("tjYear") && !Convert.IsDBNull(dr["tjYear"])) nc.tjYear = Convert.ToInt32(dr["tjYear"]); // tjYear
            if (Fileds.ContainsKey("tjSea") && !Convert.IsDBNull(dr["tjSea"])) nc.tjSea = Convert.ToInt32(dr["tjSea"]); // tjSea
            if (Fileds.ContainsKey("a1_1") && !Convert.IsDBNull(dr["a1_1"])) nc.a1_1 = Convert.ToInt32(dr["a1_1"]); // a1_1
            if (Fileds.ContainsKey("a1_2") && !Convert.IsDBNull(dr["a1_2"])) nc.a1_2 = Convert.ToInt32(dr["a1_2"]); // a1_2
            if (Fileds.ContainsKey("a1_3") && !Convert.IsDBNull(dr["a1_3"])) nc.a1_3 = Convert.ToDouble(dr["a1_3"]); // a1_3
            if (Fileds.ContainsKey("a2_1") && !Convert.IsDBNull(dr["a2_1"])) nc.a2_1 = Convert.ToInt32(dr["a2_1"]); // a2_1
            if (Fileds.ContainsKey("a2_2") && !Convert.IsDBNull(dr["a2_2"])) nc.a2_2 = Convert.ToInt32(dr["a2_2"]); // a2_2
            if (Fileds.ContainsKey("a2_3") && !Convert.IsDBNull(dr["a2_3"])) nc.a2_3 = Convert.ToDouble(dr["a2_3"]); // a2_3
            if (Fileds.ContainsKey("a3_1") && !Convert.IsDBNull(dr["a3_1"])) nc.a3_1 = Convert.ToInt32(dr["a3_1"]); // a3_1
            if (Fileds.ContainsKey("a3_2") && !Convert.IsDBNull(dr["a3_2"])) nc.a3_2 = Convert.ToInt32(dr["a3_2"]); // a3_2
            if (Fileds.ContainsKey("a3_3") && !Convert.IsDBNull(dr["a3_3"])) nc.a3_3 = Convert.ToDouble(dr["a3_3"]); // a3_3
            if (Fileds.ContainsKey("a4_1") && !Convert.IsDBNull(dr["a4_1"])) nc.a4_1 = Convert.ToInt32(dr["a4_1"]); // a4_1
            if (Fileds.ContainsKey("a4_2") && !Convert.IsDBNull(dr["a4_2"])) nc.a4_2 = Convert.ToInt32(dr["a4_2"]); // a4_2
            if (Fileds.ContainsKey("a4_3") && !Convert.IsDBNull(dr["a4_3"])) nc.a4_3 = Convert.ToDouble(dr["a4_3"]); // a4_3
            if (Fileds.ContainsKey("a5_1") && !Convert.IsDBNull(dr["a5_1"])) nc.a5_1 = Convert.ToInt32(dr["a5_1"]); // a5_1
            if (Fileds.ContainsKey("a5_2") && !Convert.IsDBNull(dr["a5_2"])) nc.a5_2 = Convert.ToInt32(dr["a5_2"]); // a5_2
            if (Fileds.ContainsKey("a5_3") && !Convert.IsDBNull(dr["a5_3"])) nc.a5_3 = Convert.ToDouble(dr["a5_3"]); // a5_3
            if (Fileds.ContainsKey("a6_1") && !Convert.IsDBNull(dr["a6_1"])) nc.a6_1 = Convert.ToInt32(dr["a6_1"]); // a6_1
            if (Fileds.ContainsKey("a6_2") && !Convert.IsDBNull(dr["a6_2"])) nc.a6_2 = Convert.ToInt32(dr["a6_2"]); // a6_2
            if (Fileds.ContainsKey("a6_3") && !Convert.IsDBNull(dr["a6_3"])) nc.a6_3 = Convert.ToDouble(dr["a6_3"]); // a6_3
            if (Fileds.ContainsKey("a7_1") && !Convert.IsDBNull(dr["a7_1"])) nc.a7_1 = Convert.ToInt32(dr["a7_1"]); // a7_1
            if (Fileds.ContainsKey("a7_2") && !Convert.IsDBNull(dr["a7_2"])) nc.a7_2 = Convert.ToInt32(dr["a7_2"]); // a7_2
            if (Fileds.ContainsKey("a7_3") && !Convert.IsDBNull(dr["a7_3"])) nc.a7_3 = Convert.ToDouble(dr["a7_3"]); // a7_3
            if (Fileds.ContainsKey("a8_1") && !Convert.IsDBNull(dr["a8_1"])) nc.a8_1 = Convert.ToInt32(dr["a8_1"]); // a8_1
            if (Fileds.ContainsKey("a8_2") && !Convert.IsDBNull(dr["a8_2"])) nc.a8_2 = Convert.ToInt32(dr["a8_2"]); // a8_2
            if (Fileds.ContainsKey("a8_3") && !Convert.IsDBNull(dr["a8_3"])) nc.a8_3 = Convert.ToDouble(dr["a8_3"]); // a8_3
            if (Fileds.ContainsKey("a9_1") && !Convert.IsDBNull(dr["a9_1"])) nc.a9_1 = Convert.ToInt32(dr["a9_1"]); // a9_1
            if (Fileds.ContainsKey("a9_2") && !Convert.IsDBNull(dr["a9_2"])) nc.a9_2 = Convert.ToInt32(dr["a9_2"]); // a9_2
            if (Fileds.ContainsKey("a9_3") && !Convert.IsDBNull(dr["a9_3"])) nc.a9_3 = Convert.ToDouble(dr["a9_3"]); // a9_3
            if (Fileds.ContainsKey("a10_1") && !Convert.IsDBNull(dr["a10_1"])) nc.a10_1 = Convert.ToInt32(dr["a10_1"]); // a10_1
            if (Fileds.ContainsKey("a10_2") && !Convert.IsDBNull(dr["a10_2"])) nc.a10_2 = Convert.ToInt32(dr["a10_2"]); // a10_2
            if (Fileds.ContainsKey("a10_3") && !Convert.IsDBNull(dr["a10_3"])) nc.a10_3 = Convert.ToDouble(dr["a10_3"]); // a10_3
            if (Fileds.ContainsKey("a11_1") && !Convert.IsDBNull(dr["a11_1"])) nc.a11_1 = Convert.ToInt32(dr["a11_1"]); // a11_1
            if (Fileds.ContainsKey("a11_2") && !Convert.IsDBNull(dr["a11_2"])) nc.a11_2 = Convert.ToInt32(dr["a11_2"]); // a11_2
            if (Fileds.ContainsKey("a11_3") && !Convert.IsDBNull(dr["a11_3"])) nc.a11_3 = Convert.ToDouble(dr["a11_3"]); // a11_3
            if (Fileds.ContainsKey("a12_1") && !Convert.IsDBNull(dr["a12_1"])) nc.a12_1 = Convert.ToInt32(dr["a12_1"]); // a12_1
            if (Fileds.ContainsKey("a12_2") && !Convert.IsDBNull(dr["a12_2"])) nc.a12_2 = Convert.ToInt32(dr["a12_2"]); // a12_2
            if (Fileds.ContainsKey("a12_3") && !Convert.IsDBNull(dr["a12_3"])) nc.a12_3 = Convert.ToDouble(dr["a12_3"]); // a12_3
            if (Fileds.ContainsKey("a13_1") && !Convert.IsDBNull(dr["a13_1"])) nc.a13_1 = Convert.ToInt32(dr["a13_1"]); // a13_1
            if (Fileds.ContainsKey("a13_2") && !Convert.IsDBNull(dr["a13_2"])) nc.a13_2 = Convert.ToInt32(dr["a13_2"]); // a13_2
            if (Fileds.ContainsKey("a13_3") && !Convert.IsDBNull(dr["a13_3"])) nc.a13_3 = Convert.ToDouble(dr["a13_3"]); // a13_3
            if (Fileds.ContainsKey("a14_1") && !Convert.IsDBNull(dr["a14_1"])) nc.a14_1 = Convert.ToInt32(dr["a14_1"]); // a14_1
            if (Fileds.ContainsKey("a14_2") && !Convert.IsDBNull(dr["a14_2"])) nc.a14_2 = Convert.ToInt32(dr["a14_2"]); // a14_2
            if (Fileds.ContainsKey("a14_3") && !Convert.IsDBNull(dr["a14_3"])) nc.a14_3 = Convert.ToDouble(dr["a14_3"]); // a14_3
            if (Fileds.ContainsKey("a15_1") && !Convert.IsDBNull(dr["a15_1"])) nc.a15_1 = Convert.ToInt32(dr["a15_1"]); // a15_1
            if (Fileds.ContainsKey("a15_2") && !Convert.IsDBNull(dr["a15_2"])) nc.a15_2 = Convert.ToInt32(dr["a15_2"]); // a15_2
            if (Fileds.ContainsKey("a15_3") && !Convert.IsDBNull(dr["a15_3"])) nc.a15_3 = Convert.ToDouble(dr["a15_3"]); // a15_3
            if (Fileds.ContainsKey("a16_1") && !Convert.IsDBNull(dr["a16_1"])) nc.a16_1 = Convert.ToInt32(dr["a16_1"]); // a16_1
            if (Fileds.ContainsKey("a16_2") && !Convert.IsDBNull(dr["a16_2"])) nc.a16_2 = Convert.ToInt32(dr["a16_2"]); // a16_2
            if (Fileds.ContainsKey("a16_3") && !Convert.IsDBNull(dr["a16_3"])) nc.a16_3 = Convert.ToDouble(dr["a16_3"]); // a16_3
            if (Fileds.ContainsKey("a17_1") && !Convert.IsDBNull(dr["a17_1"])) nc.a17_1 = Convert.ToInt32(dr["a17_1"]); // a17_1
            if (Fileds.ContainsKey("a17_2") && !Convert.IsDBNull(dr["a17_2"])) nc.a17_2 = Convert.ToInt32(dr["a17_2"]); // a17_2
            if (Fileds.ContainsKey("a17_3") && !Convert.IsDBNull(dr["a17_3"])) nc.a17_3 = Convert.ToDouble(dr["a17_3"]); // a17_3
            if (Fileds.ContainsKey("a18_1") && !Convert.IsDBNull(dr["a18_1"])) nc.a18_1 = Convert.ToInt32(dr["a18_1"]); // a18_1
            if (Fileds.ContainsKey("a18_2") && !Convert.IsDBNull(dr["a18_2"])) nc.a18_2 = Convert.ToInt32(dr["a18_2"]); // a18_2
            if (Fileds.ContainsKey("a183") && !Convert.IsDBNull(dr["a183"])) nc.a183 = Convert.ToDouble(dr["a183"]); // a183
            if (Fileds.ContainsKey("a19_1") && !Convert.IsDBNull(dr["a19_1"])) nc.a19_1 = Convert.ToInt32(dr["a19_1"]); // a19_1
            if (Fileds.ContainsKey("a19_2") && !Convert.IsDBNull(dr["a19_2"])) nc.a19_2 = Convert.ToInt32(dr["a19_2"]); // a19_2
            if (Fileds.ContainsKey("a19_3") && !Convert.IsDBNull(dr["a19_3"])) nc.a19_3 = Convert.ToDouble(dr["a19_3"]); // a19_3
            if (Fileds.ContainsKey("a20_1") && !Convert.IsDBNull(dr["a20_1"])) nc.a20_1 = Convert.ToInt32(dr["a20_1"]); // a20_1
            if (Fileds.ContainsKey("a20_2") && !Convert.IsDBNull(dr["a20_2"])) nc.a20_2 = Convert.ToInt32(dr["a20_2"]); // a20_2
            if (Fileds.ContainsKey("a20_3") && !Convert.IsDBNull(dr["a20_3"])) nc.a20_3 = Convert.ToDouble(dr["a20_3"]); // a20_3
            if (Fileds.ContainsKey("a21_1") && !Convert.IsDBNull(dr["a21_1"])) nc.a21_1 = Convert.ToInt32(dr["a21_1"]); // a21_1
            if (Fileds.ContainsKey("a21_2") && !Convert.IsDBNull(dr["a21_2"])) nc.a21_2 = Convert.ToInt32(dr["a21_2"]); // a21_2
            if (Fileds.ContainsKey("a21_3") && !Convert.IsDBNull(dr["a21_3"])) nc.a21_3 = Convert.ToDouble(dr["a21_3"]); // a21_3
            if (Fileds.ContainsKey("a22_1") && !Convert.IsDBNull(dr["a22_1"])) nc.a22_1 = Convert.ToInt32(dr["a22_1"]); // a22_1
            if (Fileds.ContainsKey("a22_2") && !Convert.IsDBNull(dr["a22_2"])) nc.a22_2 = Convert.ToInt32(dr["a22_2"]); // a22_2
            if (Fileds.ContainsKey("a22_3") && !Convert.IsDBNull(dr["a22_3"])) nc.a22_3 = Convert.ToDouble(dr["a22_3"]); // a22_3
            if (Fileds.ContainsKey("dep") && !Convert.IsDBNull(dr["dep"])) nc.dep = Convert.ToString(dr["dep"]).Trim(); // dep
            if (Fileds.ContainsKey("tj") && !Convert.IsDBNull(dr["tj"])) nc.tj = Convert.ToString(dr["tj"]).Trim(); // tj
            if (Fileds.ContainsKey("phone") && !Convert.IsDBNull(dr["phone"])) nc.phone = Convert.ToString(dr["phone"]).Trim(); // phone
            if (Fileds.ContainsKey("tjGroup") && !Convert.IsDBNull(dr["tjGroup"])) nc.tjGroup = Convert.ToInt32(dr["tjGroup"]); // tjGroup
            if (Fileds.ContainsKey("AddDate") && !Convert.IsDBNull(dr["AddDate"])) nc.AddDate = Convert.ToDateTime(dr["AddDate"]); // AddDate
            return nc;
        }
        #endregion

        #region "LFYear(来访季报表) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 LFYearEntity (来访季报表)
        /// </summary>
        /// <param name="fam">LFYear实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 LFYearInsertUpdateDelete(LFYearEntity fam);

        /// <summary>
        /// 返回LFYearEntity实体类的List对象 (来访季报表)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>LFYearEntity实体类的List对象(来访季报表)</returns>
        public abstract List<LFYearEntity> LFYearList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为LFYearEntity实体类 (来访季报表)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>LFYearEntity</returns>
        protected LFYearEntity PopulateLFYearEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            LFYearEntity nc = new LFYearEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("tjYear") && !Convert.IsDBNull(dr["tjYear"])) nc.tjYear = Convert.ToInt32(dr["tjYear"]); // tjYear
            if (Fileds.ContainsKey("a1_1") && !Convert.IsDBNull(dr["a1_1"])) nc.a1_1 = Convert.ToInt32(dr["a1_1"]); // a1_1
            if (Fileds.ContainsKey("a1_2") && !Convert.IsDBNull(dr["a1_2"])) nc.a1_2 = Convert.ToInt32(dr["a1_2"]); // a1_2
            if (Fileds.ContainsKey("a1_3") && !Convert.IsDBNull(dr["a1_3"])) nc.a1_3 = Convert.ToDouble(dr["a1_3"]); // a1_3
            if (Fileds.ContainsKey("a2_1") && !Convert.IsDBNull(dr["a2_1"])) nc.a2_1 = Convert.ToInt32(dr["a2_1"]); // a2_1
            if (Fileds.ContainsKey("a2_2") && !Convert.IsDBNull(dr["a2_2"])) nc.a2_2 = Convert.ToInt32(dr["a2_2"]); // a2_2
            if (Fileds.ContainsKey("a2_3") && !Convert.IsDBNull(dr["a2_3"])) nc.a2_3 = Convert.ToDouble(dr["a2_3"]); // a2_3
            if (Fileds.ContainsKey("a3_1") && !Convert.IsDBNull(dr["a3_1"])) nc.a3_1 = Convert.ToInt32(dr["a3_1"]); // a3_1
            if (Fileds.ContainsKey("a3_2") && !Convert.IsDBNull(dr["a3_2"])) nc.a3_2 = Convert.ToInt32(dr["a3_2"]); // a3_2
            if (Fileds.ContainsKey("a3_3") && !Convert.IsDBNull(dr["a3_3"])) nc.a3_3 = Convert.ToDouble(dr["a3_3"]); // a3_3
            if (Fileds.ContainsKey("a4_1") && !Convert.IsDBNull(dr["a4_1"])) nc.a4_1 = Convert.ToInt32(dr["a4_1"]); // a4_1
            if (Fileds.ContainsKey("a4_2") && !Convert.IsDBNull(dr["a4_2"])) nc.a4_2 = Convert.ToInt32(dr["a4_2"]); // a4_2
            if (Fileds.ContainsKey("a4_3") && !Convert.IsDBNull(dr["a4_3"])) nc.a4_3 = Convert.ToDouble(dr["a4_3"]); // a4_3
            if (Fileds.ContainsKey("a5_1") && !Convert.IsDBNull(dr["a5_1"])) nc.a5_1 = Convert.ToInt32(dr["a5_1"]); // a5_1
            if (Fileds.ContainsKey("a5_2") && !Convert.IsDBNull(dr["a5_2"])) nc.a5_2 = Convert.ToInt32(dr["a5_2"]); // a5_2
            if (Fileds.ContainsKey("a5_3") && !Convert.IsDBNull(dr["a5_3"])) nc.a5_3 = Convert.ToDouble(dr["a5_3"]); // a5_3
            if (Fileds.ContainsKey("a6_1") && !Convert.IsDBNull(dr["a6_1"])) nc.a6_1 = Convert.ToInt32(dr["a6_1"]); // a6_1
            if (Fileds.ContainsKey("a6_2") && !Convert.IsDBNull(dr["a6_2"])) nc.a6_2 = Convert.ToInt32(dr["a6_2"]); // a6_2
            if (Fileds.ContainsKey("a6_3") && !Convert.IsDBNull(dr["a6_3"])) nc.a6_3 = Convert.ToDouble(dr["a6_3"]); // a6_3
            if (Fileds.ContainsKey("a7_1") && !Convert.IsDBNull(dr["a7_1"])) nc.a7_1 = Convert.ToInt32(dr["a7_1"]); // a7_1
            if (Fileds.ContainsKey("a7_2") && !Convert.IsDBNull(dr["a7_2"])) nc.a7_2 = Convert.ToInt32(dr["a7_2"]); // a7_2
            if (Fileds.ContainsKey("a7_3") && !Convert.IsDBNull(dr["a7_3"])) nc.a7_3 = Convert.ToDouble(dr["a7_3"]); // a7_3
            if (Fileds.ContainsKey("a8_1") && !Convert.IsDBNull(dr["a8_1"])) nc.a8_1 = Convert.ToInt32(dr["a8_1"]); // a8_1
            if (Fileds.ContainsKey("a8_2") && !Convert.IsDBNull(dr["a8_2"])) nc.a8_2 = Convert.ToInt32(dr["a8_2"]); // a8_2
            if (Fileds.ContainsKey("a8_3") && !Convert.IsDBNull(dr["a8_3"])) nc.a8_3 = Convert.ToDouble(dr["a8_3"]); // a8_3
            if (Fileds.ContainsKey("a9_1") && !Convert.IsDBNull(dr["a9_1"])) nc.a9_1 = Convert.ToInt32(dr["a9_1"]); // a9_1
            if (Fileds.ContainsKey("a9_2") && !Convert.IsDBNull(dr["a9_2"])) nc.a9_2 = Convert.ToInt32(dr["a9_2"]); // a9_2
            if (Fileds.ContainsKey("a9_3") && !Convert.IsDBNull(dr["a9_3"])) nc.a9_3 = Convert.ToDouble(dr["a9_3"]); // a9_3
            if (Fileds.ContainsKey("a10_1") && !Convert.IsDBNull(dr["a10_1"])) nc.a10_1 = Convert.ToInt32(dr["a10_1"]); // a10_1
            if (Fileds.ContainsKey("a10_2") && !Convert.IsDBNull(dr["a10_2"])) nc.a10_2 = Convert.ToInt32(dr["a10_2"]); // a10_2
            if (Fileds.ContainsKey("a10_3") && !Convert.IsDBNull(dr["a10_3"])) nc.a10_3 = Convert.ToDouble(dr["a10_3"]); // a10_3
            if (Fileds.ContainsKey("a11_1") && !Convert.IsDBNull(dr["a11_1"])) nc.a11_1 = Convert.ToInt32(dr["a11_1"]); // a11_1
            if (Fileds.ContainsKey("a11_2") && !Convert.IsDBNull(dr["a11_2"])) nc.a11_2 = Convert.ToInt32(dr["a11_2"]); // a11_2
            if (Fileds.ContainsKey("a11_3") && !Convert.IsDBNull(dr["a11_3"])) nc.a11_3 = Convert.ToDouble(dr["a11_3"]); // a11_3
            if (Fileds.ContainsKey("a12_1") && !Convert.IsDBNull(dr["a12_1"])) nc.a12_1 = Convert.ToInt32(dr["a12_1"]); // a12_1
            if (Fileds.ContainsKey("a12_2") && !Convert.IsDBNull(dr["a12_2"])) nc.a12_2 = Convert.ToInt32(dr["a12_2"]); // a12_2
            if (Fileds.ContainsKey("a12_3") && !Convert.IsDBNull(dr["a12_3"])) nc.a12_3 = Convert.ToDouble(dr["a12_3"]); // a12_3
            if (Fileds.ContainsKey("a13_1") && !Convert.IsDBNull(dr["a13_1"])) nc.a13_1 = Convert.ToInt32(dr["a13_1"]); // a13_1
            if (Fileds.ContainsKey("a13_2") && !Convert.IsDBNull(dr["a13_2"])) nc.a13_2 = Convert.ToInt32(dr["a13_2"]); // a13_2
            if (Fileds.ContainsKey("a13_3") && !Convert.IsDBNull(dr["a13_3"])) nc.a13_3 = Convert.ToDouble(dr["a13_3"]); // a13_3
            if (Fileds.ContainsKey("a14_1") && !Convert.IsDBNull(dr["a14_1"])) nc.a14_1 = Convert.ToInt32(dr["a14_1"]); // a14_1
            if (Fileds.ContainsKey("a14_2") && !Convert.IsDBNull(dr["a14_2"])) nc.a14_2 = Convert.ToInt32(dr["a14_2"]); // a14_2
            if (Fileds.ContainsKey("a14_3") && !Convert.IsDBNull(dr["a14_3"])) nc.a14_3 = Convert.ToDouble(dr["a14_3"]); // a14_3
            if (Fileds.ContainsKey("a15_1") && !Convert.IsDBNull(dr["a15_1"])) nc.a15_1 = Convert.ToInt32(dr["a15_1"]); // a15_1
            if (Fileds.ContainsKey("a15_2") && !Convert.IsDBNull(dr["a15_2"])) nc.a15_2 = Convert.ToInt32(dr["a15_2"]); // a15_2
            if (Fileds.ContainsKey("a15_3") && !Convert.IsDBNull(dr["a15_3"])) nc.a15_3 = Convert.ToDouble(dr["a15_3"]); // a15_3
            if (Fileds.ContainsKey("a16_1") && !Convert.IsDBNull(dr["a16_1"])) nc.a16_1 = Convert.ToInt32(dr["a16_1"]); // a16_1
            if (Fileds.ContainsKey("a16_2") && !Convert.IsDBNull(dr["a16_2"])) nc.a16_2 = Convert.ToInt32(dr["a16_2"]); // a16_2
            if (Fileds.ContainsKey("a16_3") && !Convert.IsDBNull(dr["a16_3"])) nc.a16_3 = Convert.ToDouble(dr["a16_3"]); // a16_3
            if (Fileds.ContainsKey("a17_1") && !Convert.IsDBNull(dr["a17_1"])) nc.a17_1 = Convert.ToInt32(dr["a17_1"]); // a17_1
            if (Fileds.ContainsKey("a17_2") && !Convert.IsDBNull(dr["a17_2"])) nc.a17_2 = Convert.ToInt32(dr["a17_2"]); // a17_2
            if (Fileds.ContainsKey("a17_3") && !Convert.IsDBNull(dr["a17_3"])) nc.a17_3 = Convert.ToDouble(dr["a17_3"]); // a17_3
            if (Fileds.ContainsKey("a18_1") && !Convert.IsDBNull(dr["a18_1"])) nc.a18_1 = Convert.ToInt32(dr["a18_1"]); // a18_1
            if (Fileds.ContainsKey("a18_2") && !Convert.IsDBNull(dr["a18_2"])) nc.a18_2 = Convert.ToInt32(dr["a18_2"]); // a18_2
            if (Fileds.ContainsKey("a183") && !Convert.IsDBNull(dr["a183"])) nc.a183 = Convert.ToDouble(dr["a183"]); // a183
            if (Fileds.ContainsKey("a19_1") && !Convert.IsDBNull(dr["a19_1"])) nc.a19_1 = Convert.ToInt32(dr["a19_1"]); // a19_1
            if (Fileds.ContainsKey("a19_2") && !Convert.IsDBNull(dr["a19_2"])) nc.a19_2 = Convert.ToInt32(dr["a19_2"]); // a19_2
            if (Fileds.ContainsKey("a19_3") && !Convert.IsDBNull(dr["a19_3"])) nc.a19_3 = Convert.ToDouble(dr["a19_3"]); // a19_3
            if (Fileds.ContainsKey("a20_1") && !Convert.IsDBNull(dr["a20_1"])) nc.a20_1 = Convert.ToInt32(dr["a20_1"]); // a20_1
            if (Fileds.ContainsKey("a20_2") && !Convert.IsDBNull(dr["a20_2"])) nc.a20_2 = Convert.ToInt32(dr["a20_2"]); // a20_2
            if (Fileds.ContainsKey("a20_3") && !Convert.IsDBNull(dr["a20_3"])) nc.a20_3 = Convert.ToDouble(dr["a20_3"]); // a20_3
            if (Fileds.ContainsKey("a21_1") && !Convert.IsDBNull(dr["a21_1"])) nc.a21_1 = Convert.ToInt32(dr["a21_1"]); // a21_1
            if (Fileds.ContainsKey("a21_2") && !Convert.IsDBNull(dr["a21_2"])) nc.a21_2 = Convert.ToInt32(dr["a21_2"]); // a21_2
            if (Fileds.ContainsKey("a21_3") && !Convert.IsDBNull(dr["a21_3"])) nc.a21_3 = Convert.ToDouble(dr["a21_3"]); // a21_3
            if (Fileds.ContainsKey("a22_1") && !Convert.IsDBNull(dr["a22_1"])) nc.a22_1 = Convert.ToInt32(dr["a22_1"]); // a22_1
            if (Fileds.ContainsKey("a22_2") && !Convert.IsDBNull(dr["a22_2"])) nc.a22_2 = Convert.ToInt32(dr["a22_2"]); // a22_2
            if (Fileds.ContainsKey("a22_3") && !Convert.IsDBNull(dr["a22_3"])) nc.a22_3 = Convert.ToDouble(dr["a22_3"]); // a22_3
            if (Fileds.ContainsKey("dep") && !Convert.IsDBNull(dr["dep"])) nc.dep = Convert.ToString(dr["dep"]).Trim(); // dep
            if (Fileds.ContainsKey("tj") && !Convert.IsDBNull(dr["tj"])) nc.tj = Convert.ToString(dr["tj"]).Trim(); // tj
            if (Fileds.ContainsKey("phone") && !Convert.IsDBNull(dr["phone"])) nc.phone = Convert.ToString(dr["phone"]).Trim(); // phone
            if (Fileds.ContainsKey("tjGroup") && !Convert.IsDBNull(dr["tjGroup"])) nc.tjGroup = Convert.ToInt32(dr["tjGroup"]); // tjGroup
            if (Fileds.ContainsKey("AddDate") && !Convert.IsDBNull(dr["AddDate"])) nc.AddDate = Convert.ToDateTime(dr["AddDate"]); // AddDate
            return nc;
        }
        #endregion

        #region "LXSea(信访工作来信季报表) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 LXSeaEntity (信访工作来信季报表)
        /// </summary>
        /// <param name="fam">LXSea实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 LXSeaInsertUpdateDelete(LXSeaEntity fam);

        /// <summary>
        /// 返回LXSeaEntity实体类的List对象 (信访工作来信季报表)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>LXSeaEntity实体类的List对象(信访工作来信季报表)</returns>
        public abstract List<LXSeaEntity> LXSeaList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为LXSeaEntity实体类 (信访工作来信季报表)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>LXSeaEntity</returns>
        protected LXSeaEntity PopulateLXSeaEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            LXSeaEntity nc = new LXSeaEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("tjYear") && !Convert.IsDBNull(dr["tjYear"])) nc.tjYear = Convert.ToInt32(dr["tjYear"]); // tjYear
            if (Fileds.ContainsKey("tjMonth") && !Convert.IsDBNull(dr["tjMonth"])) nc.tjMonth = Convert.ToInt32(dr["tjMonth"]); // tjMonth
            if (Fileds.ContainsKey("a1_1") && !Convert.IsDBNull(dr["a1_1"])) nc.a1_1 = Convert.ToInt32(dr["a1_1"]); // a1_1
            if (Fileds.ContainsKey("a1_2") && !Convert.IsDBNull(dr["a1_2"])) nc.a1_2 = Convert.ToInt32(dr["a1_2"]); // a1_2
            if (Fileds.ContainsKey("a1_3") && !Convert.IsDBNull(dr["a1_3"])) nc.a1_3 = Convert.ToDouble(dr["a1_3"]); // a1_3
            if (Fileds.ContainsKey("a1_4") && !Convert.IsDBNull(dr["a1_4"])) nc.a1_4 = Convert.ToInt32(dr["a1_4"]); // a1_4
            if (Fileds.ContainsKey("a1_5") && !Convert.IsDBNull(dr["a1_5"])) nc.a1_5 = Convert.ToInt32(dr["a1_5"]); // a1_5
            if (Fileds.ContainsKey("a1_6") && !Convert.IsDBNull(dr["a1_6"])) nc.a1_6 = Convert.ToDouble(dr["a1_6"]); // a1_6
            if (Fileds.ContainsKey("a1_7") && !Convert.IsDBNull(dr["a1_7"])) nc.a1_7 = Convert.ToInt32(dr["a1_7"]); // a1_7
            if (Fileds.ContainsKey("a1_8") && !Convert.IsDBNull(dr["a1_8"])) nc.a1_8 = Convert.ToInt32(dr["a1_8"]); // a1_8
            if (Fileds.ContainsKey("a1_9") && !Convert.IsDBNull(dr["a1_9"])) nc.a1_9 = Convert.ToDouble(dr["a1_9"]); // a1_9
            if (Fileds.ContainsKey("a2_1") && !Convert.IsDBNull(dr["a2_1"])) nc.a2_1 = Convert.ToInt32(dr["a2_1"]); // a2_1
            if (Fileds.ContainsKey("a2_2") && !Convert.IsDBNull(dr["a2_2"])) nc.a2_2 = Convert.ToInt32(dr["a2_2"]); // a2_2
            if (Fileds.ContainsKey("a2_3") && !Convert.IsDBNull(dr["a2_3"])) nc.a2_3 = Convert.ToDouble(dr["a2_3"]); // a2_3
            if (Fileds.ContainsKey("a2_4") && !Convert.IsDBNull(dr["a2_4"])) nc.a2_4 = Convert.ToInt32(dr["a2_4"]); // a2_4
            if (Fileds.ContainsKey("a2_5") && !Convert.IsDBNull(dr["a2_5"])) nc.a2_5 = Convert.ToInt32(dr["a2_5"]); // a2_5
            if (Fileds.ContainsKey("a2_6") && !Convert.IsDBNull(dr["a2_6"])) nc.a2_6 = Convert.ToDouble(dr["a2_6"]); // a2_6
            if (Fileds.ContainsKey("a2_7") && !Convert.IsDBNull(dr["a2_7"])) nc.a2_7 = Convert.ToInt32(dr["a2_7"]); // a2_7
            if (Fileds.ContainsKey("a2_8") && !Convert.IsDBNull(dr["a2_8"])) nc.a2_8 = Convert.ToInt32(dr["a2_8"]); // a2_8
            if (Fileds.ContainsKey("a2_9") && !Convert.IsDBNull(dr["a2_9"])) nc.a2_9 = Convert.ToDouble(dr["a2_9"]); // a2_9
            if (Fileds.ContainsKey("a3_1") && !Convert.IsDBNull(dr["a3_1"])) nc.a3_1 = Convert.ToInt32(dr["a3_1"]); // a3_1
            if (Fileds.ContainsKey("a3_2") && !Convert.IsDBNull(dr["a3_2"])) nc.a3_2 = Convert.ToInt32(dr["a3_2"]); // a3_2
            if (Fileds.ContainsKey("a3_3") && !Convert.IsDBNull(dr["a3_3"])) nc.a3_3 = Convert.ToDouble(dr["a3_3"]); // a3_3
            if (Fileds.ContainsKey("a3_4") && !Convert.IsDBNull(dr["a3_4"])) nc.a3_4 = Convert.ToInt32(dr["a3_4"]); // a3_4
            if (Fileds.ContainsKey("a3_5") && !Convert.IsDBNull(dr["a3_5"])) nc.a3_5 = Convert.ToInt32(dr["a3_5"]); // a3_5
            if (Fileds.ContainsKey("a3_6") && !Convert.IsDBNull(dr["a3_6"])) nc.a3_6 = Convert.ToDouble(dr["a3_6"]); // a3_6
            if (Fileds.ContainsKey("a3_7") && !Convert.IsDBNull(dr["a3_7"])) nc.a3_7 = Convert.ToInt32(dr["a3_7"]); // a3_7
            if (Fileds.ContainsKey("a3_8") && !Convert.IsDBNull(dr["a3_8"])) nc.a3_8 = Convert.ToInt32(dr["a3_8"]); // a3_8
            if (Fileds.ContainsKey("a3_9") && !Convert.IsDBNull(dr["a3_9"])) nc.a3_9 = Convert.ToDouble(dr["a3_9"]); // a3_9
            if (Fileds.ContainsKey("a4_1") && !Convert.IsDBNull(dr["a4_1"])) nc.a4_1 = Convert.ToInt32(dr["a4_1"]); // a4_1
            if (Fileds.ContainsKey("a4_2") && !Convert.IsDBNull(dr["a4_2"])) nc.a4_2 = Convert.ToInt32(dr["a4_2"]); // a4_2
            if (Fileds.ContainsKey("a4_3") && !Convert.IsDBNull(dr["a4_3"])) nc.a4_3 = Convert.ToDouble(dr["a4_3"]); // a4_3
            if (Fileds.ContainsKey("a4_4") && !Convert.IsDBNull(dr["a4_4"])) nc.a4_4 = Convert.ToInt32(dr["a4_4"]); // a4_4
            if (Fileds.ContainsKey("a4_5") && !Convert.IsDBNull(dr["a4_5"])) nc.a4_5 = Convert.ToInt32(dr["a4_5"]); // a4_5
            if (Fileds.ContainsKey("a4_6") && !Convert.IsDBNull(dr["a4_6"])) nc.a4_6 = Convert.ToDouble(dr["a4_6"]); // a4_6
            if (Fileds.ContainsKey("a4_7") && !Convert.IsDBNull(dr["a4_7"])) nc.a4_7 = Convert.ToInt32(dr["a4_7"]); // a4_7
            if (Fileds.ContainsKey("a4_8") && !Convert.IsDBNull(dr["a4_8"])) nc.a4_8 = Convert.ToInt32(dr["a4_8"]); // a4_8
            if (Fileds.ContainsKey("a4_9") && !Convert.IsDBNull(dr["a4_9"])) nc.a4_9 = Convert.ToDouble(dr["a4_9"]); // a4_9
            if (Fileds.ContainsKey("a5_1") && !Convert.IsDBNull(dr["a5_1"])) nc.a5_1 = Convert.ToInt32(dr["a5_1"]); // a5_1
            if (Fileds.ContainsKey("a5_2") && !Convert.IsDBNull(dr["a5_2"])) nc.a5_2 = Convert.ToInt32(dr["a5_2"]); // a5_2
            if (Fileds.ContainsKey("a5_3") && !Convert.IsDBNull(dr["a5_3"])) nc.a5_3 = Convert.ToDouble(dr["a5_3"]); // a5_3
            if (Fileds.ContainsKey("a5_4") && !Convert.IsDBNull(dr["a5_4"])) nc.a5_4 = Convert.ToInt32(dr["a5_4"]); // a5_4
            if (Fileds.ContainsKey("a5_5") && !Convert.IsDBNull(dr["a5_5"])) nc.a5_5 = Convert.ToInt32(dr["a5_5"]); // a5_5
            if (Fileds.ContainsKey("a5_6") && !Convert.IsDBNull(dr["a5_6"])) nc.a5_6 = Convert.ToDouble(dr["a5_6"]); // a5_6
            if (Fileds.ContainsKey("a5_7") && !Convert.IsDBNull(dr["a5_7"])) nc.a5_7 = Convert.ToInt32(dr["a5_7"]); // a5_7
            if (Fileds.ContainsKey("a5_8") && !Convert.IsDBNull(dr["a5_8"])) nc.a5_8 = Convert.ToInt32(dr["a5_8"]); // a5_8
            if (Fileds.ContainsKey("a5_9") && !Convert.IsDBNull(dr["a5_9"])) nc.a5_9 = Convert.ToDouble(dr["a5_9"]); // a5_9
            if (Fileds.ContainsKey("a6_1") && !Convert.IsDBNull(dr["a6_1"])) nc.a6_1 = Convert.ToInt32(dr["a6_1"]); // a6_1
            if (Fileds.ContainsKey("a6_2") && !Convert.IsDBNull(dr["a6_2"])) nc.a6_2 = Convert.ToInt32(dr["a6_2"]); // a6_2
            if (Fileds.ContainsKey("a6_3") && !Convert.IsDBNull(dr["a6_3"])) nc.a6_3 = Convert.ToDouble(dr["a6_3"]); // a6_3
            if (Fileds.ContainsKey("a6_4") && !Convert.IsDBNull(dr["a6_4"])) nc.a6_4 = Convert.ToInt32(dr["a6_4"]); // a6_4
            if (Fileds.ContainsKey("a6_5") && !Convert.IsDBNull(dr["a6_5"])) nc.a6_5 = Convert.ToInt32(dr["a6_5"]); // a6_5
            if (Fileds.ContainsKey("a6_6") && !Convert.IsDBNull(dr["a6_6"])) nc.a6_6 = Convert.ToDouble(dr["a6_6"]); // a6_6
            if (Fileds.ContainsKey("a6_7") && !Convert.IsDBNull(dr["a6_7"])) nc.a6_7 = Convert.ToInt32(dr["a6_7"]); // a6_7
            if (Fileds.ContainsKey("a6_8") && !Convert.IsDBNull(dr["a6_8"])) nc.a6_8 = Convert.ToInt32(dr["a6_8"]); // a6_8
            if (Fileds.ContainsKey("a6_9") && !Convert.IsDBNull(dr["a6_9"])) nc.a6_9 = Convert.ToDouble(dr["a6_9"]); // a6_9
            if (Fileds.ContainsKey("a7_1") && !Convert.IsDBNull(dr["a7_1"])) nc.a7_1 = Convert.ToInt32(dr["a7_1"]); // a7_1
            if (Fileds.ContainsKey("a7_2") && !Convert.IsDBNull(dr["a7_2"])) nc.a7_2 = Convert.ToInt32(dr["a7_2"]); // a7_2
            if (Fileds.ContainsKey("a7_3") && !Convert.IsDBNull(dr["a7_3"])) nc.a7_3 = Convert.ToDouble(dr["a7_3"]); // a7_3
            if (Fileds.ContainsKey("a7_4") && !Convert.IsDBNull(dr["a7_4"])) nc.a7_4 = Convert.ToInt32(dr["a7_4"]); // a7_4
            if (Fileds.ContainsKey("a7_5") && !Convert.IsDBNull(dr["a7_5"])) nc.a7_5 = Convert.ToInt32(dr["a7_5"]); // a7_5
            if (Fileds.ContainsKey("a7_6") && !Convert.IsDBNull(dr["a7_6"])) nc.a7_6 = Convert.ToDouble(dr["a7_6"]); // a7_6
            if (Fileds.ContainsKey("a7_7") && !Convert.IsDBNull(dr["a7_7"])) nc.a7_7 = Convert.ToInt32(dr["a7_7"]); // a7_7
            if (Fileds.ContainsKey("a7_8") && !Convert.IsDBNull(dr["a7_8"])) nc.a7_8 = Convert.ToInt32(dr["a7_8"]); // a7_8
            if (Fileds.ContainsKey("a7_9") && !Convert.IsDBNull(dr["a7_9"])) nc.a7_9 = Convert.ToDouble(dr["a7_9"]); // a7_9
            if (Fileds.ContainsKey("a8_1") && !Convert.IsDBNull(dr["a8_1"])) nc.a8_1 = Convert.ToInt32(dr["a8_1"]); // a8_1
            if (Fileds.ContainsKey("a8_2") && !Convert.IsDBNull(dr["a8_2"])) nc.a8_2 = Convert.ToInt32(dr["a8_2"]); // a8_2
            if (Fileds.ContainsKey("a8_3") && !Convert.IsDBNull(dr["a8_3"])) nc.a8_3 = Convert.ToDouble(dr["a8_3"]); // a8_3
            if (Fileds.ContainsKey("a8_4") && !Convert.IsDBNull(dr["a8_4"])) nc.a8_4 = Convert.ToInt32(dr["a8_4"]); // a8_4
            if (Fileds.ContainsKey("a8_5") && !Convert.IsDBNull(dr["a8_5"])) nc.a8_5 = Convert.ToInt32(dr["a8_5"]); // a8_5
            if (Fileds.ContainsKey("a8_6") && !Convert.IsDBNull(dr["a8_6"])) nc.a8_6 = Convert.ToDouble(dr["a8_6"]); // a8_6
            if (Fileds.ContainsKey("a8_7") && !Convert.IsDBNull(dr["a8_7"])) nc.a8_7 = Convert.ToInt32(dr["a8_7"]); // a8_7
            if (Fileds.ContainsKey("a8_8") && !Convert.IsDBNull(dr["a8_8"])) nc.a8_8 = Convert.ToInt32(dr["a8_8"]); // a8_8
            if (Fileds.ContainsKey("a8_9") && !Convert.IsDBNull(dr["a8_9"])) nc.a8_9 = Convert.ToDouble(dr["a8_9"]); // a8_9
            if (Fileds.ContainsKey("a9_1") && !Convert.IsDBNull(dr["a9_1"])) nc.a9_1 = Convert.ToInt32(dr["a9_1"]); // a9_1
            if (Fileds.ContainsKey("a9_2") && !Convert.IsDBNull(dr["a9_2"])) nc.a9_2 = Convert.ToInt32(dr["a9_2"]); // a9_2
            if (Fileds.ContainsKey("a9_3") && !Convert.IsDBNull(dr["a9_3"])) nc.a9_3 = Convert.ToDouble(dr["a9_3"]); // a9_3
            if (Fileds.ContainsKey("a9_4") && !Convert.IsDBNull(dr["a9_4"])) nc.a9_4 = Convert.ToInt32(dr["a9_4"]); // a9_4
            if (Fileds.ContainsKey("a9_5") && !Convert.IsDBNull(dr["a9_5"])) nc.a9_5 = Convert.ToInt32(dr["a9_5"]); // a9_5
            if (Fileds.ContainsKey("a9_6") && !Convert.IsDBNull(dr["a9_6"])) nc.a9_6 = Convert.ToDouble(dr["a9_6"]); // a9_6
            if (Fileds.ContainsKey("a9_7") && !Convert.IsDBNull(dr["a9_7"])) nc.a9_7 = Convert.ToInt32(dr["a9_7"]); // a9_7
            if (Fileds.ContainsKey("a9_8") && !Convert.IsDBNull(dr["a9_8"])) nc.a9_8 = Convert.ToInt32(dr["a9_8"]); // a9_8
            if (Fileds.ContainsKey("a9_9") && !Convert.IsDBNull(dr["a9_9"])) nc.a9_9 = Convert.ToDouble(dr["a9_9"]); // a9_9
            if (Fileds.ContainsKey("a10_1") && !Convert.IsDBNull(dr["a10_1"])) nc.a10_1 = Convert.ToInt32(dr["a10_1"]); // a10_1
            if (Fileds.ContainsKey("a10_2") && !Convert.IsDBNull(dr["a10_2"])) nc.a10_2 = Convert.ToInt32(dr["a10_2"]); // a10_2
            if (Fileds.ContainsKey("a10_3") && !Convert.IsDBNull(dr["a10_3"])) nc.a10_3 = Convert.ToDouble(dr["a10_3"]); // a10_3
            if (Fileds.ContainsKey("a10_4") && !Convert.IsDBNull(dr["a10_4"])) nc.a10_4 = Convert.ToInt32(dr["a10_4"]); // a10_4
            if (Fileds.ContainsKey("a10_5") && !Convert.IsDBNull(dr["a10_5"])) nc.a10_5 = Convert.ToInt32(dr["a10_5"]); // a10_5
            if (Fileds.ContainsKey("a10_6") && !Convert.IsDBNull(dr["a10_6"])) nc.a10_6 = Convert.ToDouble(dr["a10_6"]); // a10_6
            if (Fileds.ContainsKey("a10_7") && !Convert.IsDBNull(dr["a10_7"])) nc.a10_7 = Convert.ToInt32(dr["a10_7"]); // a10_7
            if (Fileds.ContainsKey("a10_8") && !Convert.IsDBNull(dr["a10_8"])) nc.a10_8 = Convert.ToInt32(dr["a10_8"]); // a10_8
            if (Fileds.ContainsKey("a10_9") && !Convert.IsDBNull(dr["a10_9"])) nc.a10_9 = Convert.ToDouble(dr["a10_9"]); // a10_9
            if (Fileds.ContainsKey("a11_1") && !Convert.IsDBNull(dr["a11_1"])) nc.a11_1 = Convert.ToInt32(dr["a11_1"]); // a11_1
            if (Fileds.ContainsKey("a11_2") && !Convert.IsDBNull(dr["a11_2"])) nc.a11_2 = Convert.ToInt32(dr["a11_2"]); // a11_2
            if (Fileds.ContainsKey("a11_3") && !Convert.IsDBNull(dr["a11_3"])) nc.a11_3 = Convert.ToDouble(dr["a11_3"]); // a11_3
            if (Fileds.ContainsKey("a11_4") && !Convert.IsDBNull(dr["a11_4"])) nc.a11_4 = Convert.ToInt32(dr["a11_4"]); // a11_4
            if (Fileds.ContainsKey("a11_5") && !Convert.IsDBNull(dr["a11_5"])) nc.a11_5 = Convert.ToInt32(dr["a11_5"]); // a11_5
            if (Fileds.ContainsKey("a11_6") && !Convert.IsDBNull(dr["a11_6"])) nc.a11_6 = Convert.ToDouble(dr["a11_6"]); // a11_6
            if (Fileds.ContainsKey("a11_7") && !Convert.IsDBNull(dr["a11_7"])) nc.a11_7 = Convert.ToInt32(dr["a11_7"]); // a11_7
            if (Fileds.ContainsKey("a11_8") && !Convert.IsDBNull(dr["a11_8"])) nc.a11_8 = Convert.ToInt32(dr["a11_8"]); // a11_8
            if (Fileds.ContainsKey("a11_9") && !Convert.IsDBNull(dr["a11_9"])) nc.a11_9 = Convert.ToDouble(dr["a11_9"]); // a11_9
            if (Fileds.ContainsKey("a12_1") && !Convert.IsDBNull(dr["a12_1"])) nc.a12_1 = Convert.ToInt32(dr["a12_1"]); // a12_1
            if (Fileds.ContainsKey("a12_2") && !Convert.IsDBNull(dr["a12_2"])) nc.a12_2 = Convert.ToInt32(dr["a12_2"]); // a12_2
            if (Fileds.ContainsKey("a12_3") && !Convert.IsDBNull(dr["a12_3"])) nc.a12_3 = Convert.ToDouble(dr["a12_3"]); // a12_3
            if (Fileds.ContainsKey("a12_4") && !Convert.IsDBNull(dr["a12_4"])) nc.a12_4 = Convert.ToInt32(dr["a12_4"]); // a12_4
            if (Fileds.ContainsKey("a12_5") && !Convert.IsDBNull(dr["a12_5"])) nc.a12_5 = Convert.ToInt32(dr["a12_5"]); // a12_5
            if (Fileds.ContainsKey("a12_6") && !Convert.IsDBNull(dr["a12_6"])) nc.a12_6 = Convert.ToDouble(dr["a12_6"]); // a12_6
            if (Fileds.ContainsKey("a12_7") && !Convert.IsDBNull(dr["a12_7"])) nc.a12_7 = Convert.ToInt32(dr["a12_7"]); // a12_7
            if (Fileds.ContainsKey("a12_8") && !Convert.IsDBNull(dr["a12_8"])) nc.a12_8 = Convert.ToInt32(dr["a12_8"]); // a12_8
            if (Fileds.ContainsKey("a12_9") && !Convert.IsDBNull(dr["a12_9"])) nc.a12_9 = Convert.ToDouble(dr["a12_9"]); // a12_9
            if (Fileds.ContainsKey("a13_1") && !Convert.IsDBNull(dr["a13_1"])) nc.a13_1 = Convert.ToInt32(dr["a13_1"]); // a13_1
            if (Fileds.ContainsKey("a13_2") && !Convert.IsDBNull(dr["a13_2"])) nc.a13_2 = Convert.ToInt32(dr["a13_2"]); // a13_2
            if (Fileds.ContainsKey("a13_3") && !Convert.IsDBNull(dr["a13_3"])) nc.a13_3 = Convert.ToDouble(dr["a13_3"]); // a13_3
            if (Fileds.ContainsKey("a13_4") && !Convert.IsDBNull(dr["a13_4"])) nc.a13_4 = Convert.ToInt32(dr["a13_4"]); // a13_4
            if (Fileds.ContainsKey("a13_5") && !Convert.IsDBNull(dr["a13_5"])) nc.a13_5 = Convert.ToInt32(dr["a13_5"]); // a13_5
            if (Fileds.ContainsKey("a13_6") && !Convert.IsDBNull(dr["a13_6"])) nc.a13_6 = Convert.ToDouble(dr["a13_6"]); // a13_6
            if (Fileds.ContainsKey("a13_7") && !Convert.IsDBNull(dr["a13_7"])) nc.a13_7 = Convert.ToInt32(dr["a13_7"]); // a13_7
            if (Fileds.ContainsKey("a13_8") && !Convert.IsDBNull(dr["a13_8"])) nc.a13_8 = Convert.ToInt32(dr["a13_8"]); // a13_8
            if (Fileds.ContainsKey("a13_9") && !Convert.IsDBNull(dr["a13_9"])) nc.a13_9 = Convert.ToDouble(dr["a13_9"]); // a13_9
            if (Fileds.ContainsKey("a14_1") && !Convert.IsDBNull(dr["a14_1"])) nc.a14_1 = Convert.ToInt32(dr["a14_1"]); // a14_1
            if (Fileds.ContainsKey("a14_2") && !Convert.IsDBNull(dr["a14_2"])) nc.a14_2 = Convert.ToInt32(dr["a14_2"]); // a14_2
            if (Fileds.ContainsKey("a14_3") && !Convert.IsDBNull(dr["a14_3"])) nc.a14_3 = Convert.ToDouble(dr["a14_3"]); // a14_3
            if (Fileds.ContainsKey("a14_4") && !Convert.IsDBNull(dr["a14_4"])) nc.a14_4 = Convert.ToInt32(dr["a14_4"]); // a14_4
            if (Fileds.ContainsKey("a14_5") && !Convert.IsDBNull(dr["a14_5"])) nc.a14_5 = Convert.ToInt32(dr["a14_5"]); // a14_5
            if (Fileds.ContainsKey("a14_6") && !Convert.IsDBNull(dr["a14_6"])) nc.a14_6 = Convert.ToDouble(dr["a14_6"]); // a14_6
            if (Fileds.ContainsKey("a14_7") && !Convert.IsDBNull(dr["a14_7"])) nc.a14_7 = Convert.ToInt32(dr["a14_7"]); // a14_7
            if (Fileds.ContainsKey("a14_8") && !Convert.IsDBNull(dr["a14_8"])) nc.a14_8 = Convert.ToInt32(dr["a14_8"]); // a14_8
            if (Fileds.ContainsKey("a14_9") && !Convert.IsDBNull(dr["a14_9"])) nc.a14_9 = Convert.ToDouble(dr["a14_9"]); // a14_9
            if (Fileds.ContainsKey("a15_1") && !Convert.IsDBNull(dr["a15_1"])) nc.a15_1 = Convert.ToInt32(dr["a15_1"]); // a15_1
            if (Fileds.ContainsKey("a15_2") && !Convert.IsDBNull(dr["a15_2"])) nc.a15_2 = Convert.ToInt32(dr["a15_2"]); // a15_2
            if (Fileds.ContainsKey("a15_3") && !Convert.IsDBNull(dr["a15_3"])) nc.a15_3 = Convert.ToDouble(dr["a15_3"]); // a15_3
            if (Fileds.ContainsKey("a15_4") && !Convert.IsDBNull(dr["a15_4"])) nc.a15_4 = Convert.ToInt32(dr["a15_4"]); // a15_4
            if (Fileds.ContainsKey("a15_5") && !Convert.IsDBNull(dr["a15_5"])) nc.a15_5 = Convert.ToInt32(dr["a15_5"]); // a15_5
            if (Fileds.ContainsKey("a15_6") && !Convert.IsDBNull(dr["a15_6"])) nc.a15_6 = Convert.ToDouble(dr["a15_6"]); // a15_6
            if (Fileds.ContainsKey("a15_7") && !Convert.IsDBNull(dr["a15_7"])) nc.a15_7 = Convert.ToInt32(dr["a15_7"]); // a15_7
            if (Fileds.ContainsKey("a15_8") && !Convert.IsDBNull(dr["a15_8"])) nc.a15_8 = Convert.ToInt32(dr["a15_8"]); // a15_8
            if (Fileds.ContainsKey("a15_9") && !Convert.IsDBNull(dr["a15_9"])) nc.a15_9 = Convert.ToDouble(dr["a15_9"]); // a15_9
            if (Fileds.ContainsKey("a16_1") && !Convert.IsDBNull(dr["a16_1"])) nc.a16_1 = Convert.ToInt32(dr["a16_1"]); // a16_1
            if (Fileds.ContainsKey("a16_2") && !Convert.IsDBNull(dr["a16_2"])) nc.a16_2 = Convert.ToInt32(dr["a16_2"]); // a16_2
            if (Fileds.ContainsKey("a16_3") && !Convert.IsDBNull(dr["a16_3"])) nc.a16_3 = Convert.ToDouble(dr["a16_3"]); // a16_3
            if (Fileds.ContainsKey("a16_4") && !Convert.IsDBNull(dr["a16_4"])) nc.a16_4 = Convert.ToInt32(dr["a16_4"]); // a16_4
            if (Fileds.ContainsKey("a16_5") && !Convert.IsDBNull(dr["a16_5"])) nc.a16_5 = Convert.ToInt32(dr["a16_5"]); // a16_5
            if (Fileds.ContainsKey("a16_6") && !Convert.IsDBNull(dr["a16_6"])) nc.a16_6 = Convert.ToDouble(dr["a16_6"]); // a16_6
            if (Fileds.ContainsKey("a16_7") && !Convert.IsDBNull(dr["a16_7"])) nc.a16_7 = Convert.ToInt32(dr["a16_7"]); // a16_7
            if (Fileds.ContainsKey("a16_8") && !Convert.IsDBNull(dr["a16_8"])) nc.a16_8 = Convert.ToInt32(dr["a16_8"]); // a16_8
            if (Fileds.ContainsKey("a16_9") && !Convert.IsDBNull(dr["a16_9"])) nc.a16_9 = Convert.ToDouble(dr["a16_9"]); // a16_9
            if (Fileds.ContainsKey("a17_1") && !Convert.IsDBNull(dr["a17_1"])) nc.a17_1 = Convert.ToInt32(dr["a17_1"]); // a17_1
            if (Fileds.ContainsKey("a17_2") && !Convert.IsDBNull(dr["a17_2"])) nc.a17_2 = Convert.ToInt32(dr["a17_2"]); // a17_2
            if (Fileds.ContainsKey("a17_3") && !Convert.IsDBNull(dr["a17_3"])) nc.a17_3 = Convert.ToDouble(dr["a17_3"]); // a17_3
            if (Fileds.ContainsKey("a17_4") && !Convert.IsDBNull(dr["a17_4"])) nc.a17_4 = Convert.ToInt32(dr["a17_4"]); // a17_4
            if (Fileds.ContainsKey("a17_5") && !Convert.IsDBNull(dr["a17_5"])) nc.a17_5 = Convert.ToInt32(dr["a17_5"]); // a17_5
            if (Fileds.ContainsKey("a17_6") && !Convert.IsDBNull(dr["a17_6"])) nc.a17_6 = Convert.ToDouble(dr["a17_6"]); // a17_6
            if (Fileds.ContainsKey("a17_7") && !Convert.IsDBNull(dr["a17_7"])) nc.a17_7 = Convert.ToInt32(dr["a17_7"]); // a17_7
            if (Fileds.ContainsKey("a17_8") && !Convert.IsDBNull(dr["a17_8"])) nc.a17_8 = Convert.ToInt32(dr["a17_8"]); // a17_8
            if (Fileds.ContainsKey("a17_9") && !Convert.IsDBNull(dr["a17_9"])) nc.a17_9 = Convert.ToDouble(dr["a17_9"]); // a17_9
            if (Fileds.ContainsKey("a18_1") && !Convert.IsDBNull(dr["a18_1"])) nc.a18_1 = Convert.ToInt32(dr["a18_1"]); // a18_1
            if (Fileds.ContainsKey("a18_2") && !Convert.IsDBNull(dr["a18_2"])) nc.a18_2 = Convert.ToInt32(dr["a18_2"]); // a18_2
            if (Fileds.ContainsKey("a18_3") && !Convert.IsDBNull(dr["a18_3"])) nc.a18_3 = Convert.ToDouble(dr["a18_3"]); // a18_3
            if (Fileds.ContainsKey("a18_4") && !Convert.IsDBNull(dr["a18_4"])) nc.a18_4 = Convert.ToInt32(dr["a18_4"]); // a18_4
            if (Fileds.ContainsKey("a18_5") && !Convert.IsDBNull(dr["a18_5"])) nc.a18_5 = Convert.ToInt32(dr["a18_5"]); // a18_5
            if (Fileds.ContainsKey("a18_6") && !Convert.IsDBNull(dr["a18_6"])) nc.a18_6 = Convert.ToDouble(dr["a18_6"]); // a18_6
            if (Fileds.ContainsKey("a18_7") && !Convert.IsDBNull(dr["a18_7"])) nc.a18_7 = Convert.ToInt32(dr["a18_7"]); // a18_7
            if (Fileds.ContainsKey("a18_8") && !Convert.IsDBNull(dr["a18_8"])) nc.a18_8 = Convert.ToInt32(dr["a18_8"]); // a18_8
            if (Fileds.ContainsKey("a18_9") && !Convert.IsDBNull(dr["a18_9"])) nc.a18_9 = Convert.ToDouble(dr["a18_9"]); // a18_9
            if (Fileds.ContainsKey("a19_1") && !Convert.IsDBNull(dr["a19_1"])) nc.a19_1 = Convert.ToInt32(dr["a19_1"]); // a19_1
            if (Fileds.ContainsKey("a19_2") && !Convert.IsDBNull(dr["a19_2"])) nc.a19_2 = Convert.ToInt32(dr["a19_2"]); // a19_2
            if (Fileds.ContainsKey("a19_3") && !Convert.IsDBNull(dr["a19_3"])) nc.a19_3 = Convert.ToDouble(dr["a19_3"]); // a19_3
            if (Fileds.ContainsKey("a19_4") && !Convert.IsDBNull(dr["a19_4"])) nc.a19_4 = Convert.ToInt32(dr["a19_4"]); // a19_4
            if (Fileds.ContainsKey("a19_5") && !Convert.IsDBNull(dr["a19_5"])) nc.a19_5 = Convert.ToInt32(dr["a19_5"]); // a19_5
            if (Fileds.ContainsKey("a19_6") && !Convert.IsDBNull(dr["a19_6"])) nc.a19_6 = Convert.ToDouble(dr["a19_6"]); // a19_6
            if (Fileds.ContainsKey("a19_7") && !Convert.IsDBNull(dr["a19_7"])) nc.a19_7 = Convert.ToInt32(dr["a19_7"]); // a19_7
            if (Fileds.ContainsKey("a19_8") && !Convert.IsDBNull(dr["a19_8"])) nc.a19_8 = Convert.ToInt32(dr["a19_8"]); // a19_8
            if (Fileds.ContainsKey("a19_9") && !Convert.IsDBNull(dr["a19_9"])) nc.a19_9 = Convert.ToDouble(dr["a19_9"]); // a19_9
            if (Fileds.ContainsKey("a20_1") && !Convert.IsDBNull(dr["a20_1"])) nc.a20_1 = Convert.ToInt32(dr["a20_1"]); // a20_1
            if (Fileds.ContainsKey("a20_2") && !Convert.IsDBNull(dr["a20_2"])) nc.a20_2 = Convert.ToInt32(dr["a20_2"]); // a20_2
            if (Fileds.ContainsKey("a20_3") && !Convert.IsDBNull(dr["a20_3"])) nc.a20_3 = Convert.ToDouble(dr["a20_3"]); // a20_3
            if (Fileds.ContainsKey("a20_4") && !Convert.IsDBNull(dr["a20_4"])) nc.a20_4 = Convert.ToInt32(dr["a20_4"]); // a20_4
            if (Fileds.ContainsKey("a20_5") && !Convert.IsDBNull(dr["a20_5"])) nc.a20_5 = Convert.ToInt32(dr["a20_5"]); // a20_5
            if (Fileds.ContainsKey("a20_6") && !Convert.IsDBNull(dr["a20_6"])) nc.a20_6 = Convert.ToDouble(dr["a20_6"]); // a20_6
            if (Fileds.ContainsKey("a20_7") && !Convert.IsDBNull(dr["a20_7"])) nc.a20_7 = Convert.ToInt32(dr["a20_7"]); // a20_7
            if (Fileds.ContainsKey("a20_8") && !Convert.IsDBNull(dr["a20_8"])) nc.a20_8 = Convert.ToInt32(dr["a20_8"]); // a20_8
            if (Fileds.ContainsKey("a20_9") && !Convert.IsDBNull(dr["a20_9"])) nc.a20_9 = Convert.ToDouble(dr["a20_9"]); // a20_9
            if (Fileds.ContainsKey("a21_1") && !Convert.IsDBNull(dr["a21_1"])) nc.a21_1 = Convert.ToInt32(dr["a21_1"]); // a21_1
            if (Fileds.ContainsKey("a21_2") && !Convert.IsDBNull(dr["a21_2"])) nc.a21_2 = Convert.ToInt32(dr["a21_2"]); // a21_2
            if (Fileds.ContainsKey("a21_3") && !Convert.IsDBNull(dr["a21_3"])) nc.a21_3 = Convert.ToDouble(dr["a21_3"]); // a21_3
            if (Fileds.ContainsKey("a21_4") && !Convert.IsDBNull(dr["a21_4"])) nc.a21_4 = Convert.ToInt32(dr["a21_4"]); // a21_4
            if (Fileds.ContainsKey("a21_5") && !Convert.IsDBNull(dr["a21_5"])) nc.a21_5 = Convert.ToInt32(dr["a21_5"]); // a21_5
            if (Fileds.ContainsKey("a21_6") && !Convert.IsDBNull(dr["a21_6"])) nc.a21_6 = Convert.ToDouble(dr["a21_6"]); // a21_6
            if (Fileds.ContainsKey("a21_7") && !Convert.IsDBNull(dr["a21_7"])) nc.a21_7 = Convert.ToInt32(dr["a21_7"]); // a21_7
            if (Fileds.ContainsKey("a21_8") && !Convert.IsDBNull(dr["a21_8"])) nc.a21_8 = Convert.ToInt32(dr["a21_8"]); // a21_8
            if (Fileds.ContainsKey("a21_9") && !Convert.IsDBNull(dr["a21_9"])) nc.a21_9 = Convert.ToDouble(dr["a21_9"]); // a21_9
            if (Fileds.ContainsKey("dep") && !Convert.IsDBNull(dr["dep"])) nc.dep = Convert.ToString(dr["dep"]).Trim(); // dep
            if (Fileds.ContainsKey("tj") && !Convert.IsDBNull(dr["tj"])) nc.tj = Convert.ToString(dr["tj"]).Trim(); // tj
            if (Fileds.ContainsKey("phone") && !Convert.IsDBNull(dr["phone"])) nc.phone = Convert.ToString(dr["phone"]).Trim(); // phone
            if (Fileds.ContainsKey("tjDep") && !Convert.IsDBNull(dr["tjDep"])) nc.tjDep = Convert.ToInt32(dr["tjDep"]); // tjDep
            if (Fileds.ContainsKey("tjtime") && !Convert.IsDBNull(dr["tjtime"])) nc.tjtime = Convert.ToDateTime(dr["tjtime"]); // tjtime
            return nc;
        }
        #endregion

        #region "LXYear(信访工作来信季报表) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 LXYearEntity (信访工作来信季报表)
        /// </summary>
        /// <param name="fam">LXYear实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 LXYearInsertUpdateDelete(LXYearEntity fam);

        /// <summary>
        /// 返回LXYearEntity实体类的List对象 (信访工作来信季报表)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>LXYearEntity实体类的List对象(信访工作来信季报表)</returns>
        public abstract List<LXYearEntity> LXYearList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为LXYearEntity实体类 (信访工作来信季报表)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>LXYearEntity</returns>
        protected LXYearEntity PopulateLXYearEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            LXYearEntity nc = new LXYearEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("tjYear") && !Convert.IsDBNull(dr["tjYear"])) nc.tjYear = Convert.ToInt32(dr["tjYear"]); // tjYear
            if (Fileds.ContainsKey("a1_1") && !Convert.IsDBNull(dr["a1_1"])) nc.a1_1 = Convert.ToInt32(dr["a1_1"]); // a1_1
            if (Fileds.ContainsKey("a1_2") && !Convert.IsDBNull(dr["a1_2"])) nc.a1_2 = Convert.ToInt32(dr["a1_2"]); // a1_2
            if (Fileds.ContainsKey("a1_3") && !Convert.IsDBNull(dr["a1_3"])) nc.a1_3 = Convert.ToDouble(dr["a1_3"]); // a1_3
            if (Fileds.ContainsKey("a1_4") && !Convert.IsDBNull(dr["a1_4"])) nc.a1_4 = Convert.ToInt32(dr["a1_4"]); // a1_4
            if (Fileds.ContainsKey("a1_5") && !Convert.IsDBNull(dr["a1_5"])) nc.a1_5 = Convert.ToInt32(dr["a1_5"]); // a1_5
            if (Fileds.ContainsKey("a1_6") && !Convert.IsDBNull(dr["a1_6"])) nc.a1_6 = Convert.ToDouble(dr["a1_6"]); // a1_6
            if (Fileds.ContainsKey("a1_7") && !Convert.IsDBNull(dr["a1_7"])) nc.a1_7 = Convert.ToInt32(dr["a1_7"]); // a1_7
            if (Fileds.ContainsKey("a1_8") && !Convert.IsDBNull(dr["a1_8"])) nc.a1_8 = Convert.ToInt32(dr["a1_8"]); // a1_8
            if (Fileds.ContainsKey("a1_9") && !Convert.IsDBNull(dr["a1_9"])) nc.a1_9 = Convert.ToDouble(dr["a1_9"]); // a1_9
            if (Fileds.ContainsKey("a2_1") && !Convert.IsDBNull(dr["a2_1"])) nc.a2_1 = Convert.ToInt32(dr["a2_1"]); // a2_1
            if (Fileds.ContainsKey("a2_2") && !Convert.IsDBNull(dr["a2_2"])) nc.a2_2 = Convert.ToInt32(dr["a2_2"]); // a2_2
            if (Fileds.ContainsKey("a2_3") && !Convert.IsDBNull(dr["a2_3"])) nc.a2_3 = Convert.ToDouble(dr["a2_3"]); // a2_3
            if (Fileds.ContainsKey("a2_4") && !Convert.IsDBNull(dr["a2_4"])) nc.a2_4 = Convert.ToInt32(dr["a2_4"]); // a2_4
            if (Fileds.ContainsKey("a2_5") && !Convert.IsDBNull(dr["a2_5"])) nc.a2_5 = Convert.ToInt32(dr["a2_5"]); // a2_5
            if (Fileds.ContainsKey("a2_6") && !Convert.IsDBNull(dr["a2_6"])) nc.a2_6 = Convert.ToDouble(dr["a2_6"]); // a2_6
            if (Fileds.ContainsKey("a2_7") && !Convert.IsDBNull(dr["a2_7"])) nc.a2_7 = Convert.ToInt32(dr["a2_7"]); // a2_7
            if (Fileds.ContainsKey("a2_8") && !Convert.IsDBNull(dr["a2_8"])) nc.a2_8 = Convert.ToInt32(dr["a2_8"]); // a2_8
            if (Fileds.ContainsKey("a2_9") && !Convert.IsDBNull(dr["a2_9"])) nc.a2_9 = Convert.ToDouble(dr["a2_9"]); // a2_9
            if (Fileds.ContainsKey("a3_1") && !Convert.IsDBNull(dr["a3_1"])) nc.a3_1 = Convert.ToInt32(dr["a3_1"]); // a3_1
            if (Fileds.ContainsKey("a3_2") && !Convert.IsDBNull(dr["a3_2"])) nc.a3_2 = Convert.ToInt32(dr["a3_2"]); // a3_2
            if (Fileds.ContainsKey("a3_3") && !Convert.IsDBNull(dr["a3_3"])) nc.a3_3 = Convert.ToDouble(dr["a3_3"]); // a3_3
            if (Fileds.ContainsKey("a3_4") && !Convert.IsDBNull(dr["a3_4"])) nc.a3_4 = Convert.ToInt32(dr["a3_4"]); // a3_4
            if (Fileds.ContainsKey("a3_5") && !Convert.IsDBNull(dr["a3_5"])) nc.a3_5 = Convert.ToInt32(dr["a3_5"]); // a3_5
            if (Fileds.ContainsKey("a3_6") && !Convert.IsDBNull(dr["a3_6"])) nc.a3_6 = Convert.ToDouble(dr["a3_6"]); // a3_6
            if (Fileds.ContainsKey("a3_7") && !Convert.IsDBNull(dr["a3_7"])) nc.a3_7 = Convert.ToInt32(dr["a3_7"]); // a3_7
            if (Fileds.ContainsKey("a3_8") && !Convert.IsDBNull(dr["a3_8"])) nc.a3_8 = Convert.ToInt32(dr["a3_8"]); // a3_8
            if (Fileds.ContainsKey("a3_9") && !Convert.IsDBNull(dr["a3_9"])) nc.a3_9 = Convert.ToDouble(dr["a3_9"]); // a3_9
            if (Fileds.ContainsKey("a4_1") && !Convert.IsDBNull(dr["a4_1"])) nc.a4_1 = Convert.ToInt32(dr["a4_1"]); // a4_1
            if (Fileds.ContainsKey("a4_2") && !Convert.IsDBNull(dr["a4_2"])) nc.a4_2 = Convert.ToInt32(dr["a4_2"]); // a4_2
            if (Fileds.ContainsKey("a4_3") && !Convert.IsDBNull(dr["a4_3"])) nc.a4_3 = Convert.ToDouble(dr["a4_3"]); // a4_3
            if (Fileds.ContainsKey("a4_4") && !Convert.IsDBNull(dr["a4_4"])) nc.a4_4 = Convert.ToInt32(dr["a4_4"]); // a4_4
            if (Fileds.ContainsKey("a4_5") && !Convert.IsDBNull(dr["a4_5"])) nc.a4_5 = Convert.ToInt32(dr["a4_5"]); // a4_5
            if (Fileds.ContainsKey("a4_6") && !Convert.IsDBNull(dr["a4_6"])) nc.a4_6 = Convert.ToDouble(dr["a4_6"]); // a4_6
            if (Fileds.ContainsKey("a4_7") && !Convert.IsDBNull(dr["a4_7"])) nc.a4_7 = Convert.ToInt32(dr["a4_7"]); // a4_7
            if (Fileds.ContainsKey("a4_8") && !Convert.IsDBNull(dr["a4_8"])) nc.a4_8 = Convert.ToInt32(dr["a4_8"]); // a4_8
            if (Fileds.ContainsKey("a4_9") && !Convert.IsDBNull(dr["a4_9"])) nc.a4_9 = Convert.ToDouble(dr["a4_9"]); // a4_9
            if (Fileds.ContainsKey("a5_1") && !Convert.IsDBNull(dr["a5_1"])) nc.a5_1 = Convert.ToInt32(dr["a5_1"]); // a5_1
            if (Fileds.ContainsKey("a5_2") && !Convert.IsDBNull(dr["a5_2"])) nc.a5_2 = Convert.ToInt32(dr["a5_2"]); // a5_2
            if (Fileds.ContainsKey("a5_3") && !Convert.IsDBNull(dr["a5_3"])) nc.a5_3 = Convert.ToDouble(dr["a5_3"]); // a5_3
            if (Fileds.ContainsKey("a5_4") && !Convert.IsDBNull(dr["a5_4"])) nc.a5_4 = Convert.ToInt32(dr["a5_4"]); // a5_4
            if (Fileds.ContainsKey("a5_5") && !Convert.IsDBNull(dr["a5_5"])) nc.a5_5 = Convert.ToInt32(dr["a5_5"]); // a5_5
            if (Fileds.ContainsKey("a5_6") && !Convert.IsDBNull(dr["a5_6"])) nc.a5_6 = Convert.ToDouble(dr["a5_6"]); // a5_6
            if (Fileds.ContainsKey("a5_7") && !Convert.IsDBNull(dr["a5_7"])) nc.a5_7 = Convert.ToInt32(dr["a5_7"]); // a5_7
            if (Fileds.ContainsKey("a5_8") && !Convert.IsDBNull(dr["a5_8"])) nc.a5_8 = Convert.ToInt32(dr["a5_8"]); // a5_8
            if (Fileds.ContainsKey("a5_9") && !Convert.IsDBNull(dr["a5_9"])) nc.a5_9 = Convert.ToDouble(dr["a5_9"]); // a5_9
            if (Fileds.ContainsKey("a6_1") && !Convert.IsDBNull(dr["a6_1"])) nc.a6_1 = Convert.ToInt32(dr["a6_1"]); // a6_1
            if (Fileds.ContainsKey("a6_2") && !Convert.IsDBNull(dr["a6_2"])) nc.a6_2 = Convert.ToInt32(dr["a6_2"]); // a6_2
            if (Fileds.ContainsKey("a6_3") && !Convert.IsDBNull(dr["a6_3"])) nc.a6_3 = Convert.ToDouble(dr["a6_3"]); // a6_3
            if (Fileds.ContainsKey("a6_4") && !Convert.IsDBNull(dr["a6_4"])) nc.a6_4 = Convert.ToInt32(dr["a6_4"]); // a6_4
            if (Fileds.ContainsKey("a6_5") && !Convert.IsDBNull(dr["a6_5"])) nc.a6_5 = Convert.ToInt32(dr["a6_5"]); // a6_5
            if (Fileds.ContainsKey("a6_6") && !Convert.IsDBNull(dr["a6_6"])) nc.a6_6 = Convert.ToDouble(dr["a6_6"]); // a6_6
            if (Fileds.ContainsKey("a6_7") && !Convert.IsDBNull(dr["a6_7"])) nc.a6_7 = Convert.ToInt32(dr["a6_7"]); // a6_7
            if (Fileds.ContainsKey("a6_8") && !Convert.IsDBNull(dr["a6_8"])) nc.a6_8 = Convert.ToInt32(dr["a6_8"]); // a6_8
            if (Fileds.ContainsKey("a6_9") && !Convert.IsDBNull(dr["a6_9"])) nc.a6_9 = Convert.ToDouble(dr["a6_9"]); // a6_9
            if (Fileds.ContainsKey("a7_1") && !Convert.IsDBNull(dr["a7_1"])) nc.a7_1 = Convert.ToInt32(dr["a7_1"]); // a7_1
            if (Fileds.ContainsKey("a7_2") && !Convert.IsDBNull(dr["a7_2"])) nc.a7_2 = Convert.ToInt32(dr["a7_2"]); // a7_2
            if (Fileds.ContainsKey("a7_3") && !Convert.IsDBNull(dr["a7_3"])) nc.a7_3 = Convert.ToDouble(dr["a7_3"]); // a7_3
            if (Fileds.ContainsKey("a7_4") && !Convert.IsDBNull(dr["a7_4"])) nc.a7_4 = Convert.ToInt32(dr["a7_4"]); // a7_4
            if (Fileds.ContainsKey("a7_5") && !Convert.IsDBNull(dr["a7_5"])) nc.a7_5 = Convert.ToInt32(dr["a7_5"]); // a7_5
            if (Fileds.ContainsKey("a7_6") && !Convert.IsDBNull(dr["a7_6"])) nc.a7_6 = Convert.ToDouble(dr["a7_6"]); // a7_6
            if (Fileds.ContainsKey("a7_7") && !Convert.IsDBNull(dr["a7_7"])) nc.a7_7 = Convert.ToInt32(dr["a7_7"]); // a7_7
            if (Fileds.ContainsKey("a7_8") && !Convert.IsDBNull(dr["a7_8"])) nc.a7_8 = Convert.ToInt32(dr["a7_8"]); // a7_8
            if (Fileds.ContainsKey("a7_9") && !Convert.IsDBNull(dr["a7_9"])) nc.a7_9 = Convert.ToDouble(dr["a7_9"]); // a7_9
            if (Fileds.ContainsKey("a8_1") && !Convert.IsDBNull(dr["a8_1"])) nc.a8_1 = Convert.ToInt32(dr["a8_1"]); // a8_1
            if (Fileds.ContainsKey("a8_2") && !Convert.IsDBNull(dr["a8_2"])) nc.a8_2 = Convert.ToInt32(dr["a8_2"]); // a8_2
            if (Fileds.ContainsKey("a8_3") && !Convert.IsDBNull(dr["a8_3"])) nc.a8_3 = Convert.ToDouble(dr["a8_3"]); // a8_3
            if (Fileds.ContainsKey("a8_4") && !Convert.IsDBNull(dr["a8_4"])) nc.a8_4 = Convert.ToInt32(dr["a8_4"]); // a8_4
            if (Fileds.ContainsKey("a8_5") && !Convert.IsDBNull(dr["a8_5"])) nc.a8_5 = Convert.ToInt32(dr["a8_5"]); // a8_5
            if (Fileds.ContainsKey("a8_6") && !Convert.IsDBNull(dr["a8_6"])) nc.a8_6 = Convert.ToDouble(dr["a8_6"]); // a8_6
            if (Fileds.ContainsKey("a8_7") && !Convert.IsDBNull(dr["a8_7"])) nc.a8_7 = Convert.ToInt32(dr["a8_7"]); // a8_7
            if (Fileds.ContainsKey("a8_8") && !Convert.IsDBNull(dr["a8_8"])) nc.a8_8 = Convert.ToInt32(dr["a8_8"]); // a8_8
            if (Fileds.ContainsKey("a8_9") && !Convert.IsDBNull(dr["a8_9"])) nc.a8_9 = Convert.ToDouble(dr["a8_9"]); // a8_9
            if (Fileds.ContainsKey("a9_1") && !Convert.IsDBNull(dr["a9_1"])) nc.a9_1 = Convert.ToInt32(dr["a9_1"]); // a9_1
            if (Fileds.ContainsKey("a9_2") && !Convert.IsDBNull(dr["a9_2"])) nc.a9_2 = Convert.ToInt32(dr["a9_2"]); // a9_2
            if (Fileds.ContainsKey("a9_3") && !Convert.IsDBNull(dr["a9_3"])) nc.a9_3 = Convert.ToDouble(dr["a9_3"]); // a9_3
            if (Fileds.ContainsKey("a9_4") && !Convert.IsDBNull(dr["a9_4"])) nc.a9_4 = Convert.ToInt32(dr["a9_4"]); // a9_4
            if (Fileds.ContainsKey("a9_5") && !Convert.IsDBNull(dr["a9_5"])) nc.a9_5 = Convert.ToInt32(dr["a9_5"]); // a9_5
            if (Fileds.ContainsKey("a9_6") && !Convert.IsDBNull(dr["a9_6"])) nc.a9_6 = Convert.ToDouble(dr["a9_6"]); // a9_6
            if (Fileds.ContainsKey("a9_7") && !Convert.IsDBNull(dr["a9_7"])) nc.a9_7 = Convert.ToInt32(dr["a9_7"]); // a9_7
            if (Fileds.ContainsKey("a9_8") && !Convert.IsDBNull(dr["a9_8"])) nc.a9_8 = Convert.ToInt32(dr["a9_8"]); // a9_8
            if (Fileds.ContainsKey("a9_9") && !Convert.IsDBNull(dr["a9_9"])) nc.a9_9 = Convert.ToDouble(dr["a9_9"]); // a9_9
            if (Fileds.ContainsKey("a10_1") && !Convert.IsDBNull(dr["a10_1"])) nc.a10_1 = Convert.ToInt32(dr["a10_1"]); // a10_1
            if (Fileds.ContainsKey("a10_2") && !Convert.IsDBNull(dr["a10_2"])) nc.a10_2 = Convert.ToInt32(dr["a10_2"]); // a10_2
            if (Fileds.ContainsKey("a10_3") && !Convert.IsDBNull(dr["a10_3"])) nc.a10_3 = Convert.ToDouble(dr["a10_3"]); // a10_3
            if (Fileds.ContainsKey("a10_4") && !Convert.IsDBNull(dr["a10_4"])) nc.a10_4 = Convert.ToInt32(dr["a10_4"]); // a10_4
            if (Fileds.ContainsKey("a10_5") && !Convert.IsDBNull(dr["a10_5"])) nc.a10_5 = Convert.ToInt32(dr["a10_5"]); // a10_5
            if (Fileds.ContainsKey("a10_6") && !Convert.IsDBNull(dr["a10_6"])) nc.a10_6 = Convert.ToDouble(dr["a10_6"]); // a10_6
            if (Fileds.ContainsKey("a10_7") && !Convert.IsDBNull(dr["a10_7"])) nc.a10_7 = Convert.ToInt32(dr["a10_7"]); // a10_7
            if (Fileds.ContainsKey("a10_8") && !Convert.IsDBNull(dr["a10_8"])) nc.a10_8 = Convert.ToInt32(dr["a10_8"]); // a10_8
            if (Fileds.ContainsKey("a10_9") && !Convert.IsDBNull(dr["a10_9"])) nc.a10_9 = Convert.ToDouble(dr["a10_9"]); // a10_9
            if (Fileds.ContainsKey("a11_1") && !Convert.IsDBNull(dr["a11_1"])) nc.a11_1 = Convert.ToInt32(dr["a11_1"]); // a11_1
            if (Fileds.ContainsKey("a11_2") && !Convert.IsDBNull(dr["a11_2"])) nc.a11_2 = Convert.ToInt32(dr["a11_2"]); // a11_2
            if (Fileds.ContainsKey("a11_3") && !Convert.IsDBNull(dr["a11_3"])) nc.a11_3 = Convert.ToDouble(dr["a11_3"]); // a11_3
            if (Fileds.ContainsKey("a11_4") && !Convert.IsDBNull(dr["a11_4"])) nc.a11_4 = Convert.ToInt32(dr["a11_4"]); // a11_4
            if (Fileds.ContainsKey("a11_5") && !Convert.IsDBNull(dr["a11_5"])) nc.a11_5 = Convert.ToInt32(dr["a11_5"]); // a11_5
            if (Fileds.ContainsKey("a11_6") && !Convert.IsDBNull(dr["a11_6"])) nc.a11_6 = Convert.ToDouble(dr["a11_6"]); // a11_6
            if (Fileds.ContainsKey("a11_7") && !Convert.IsDBNull(dr["a11_7"])) nc.a11_7 = Convert.ToInt32(dr["a11_7"]); // a11_7
            if (Fileds.ContainsKey("a11_8") && !Convert.IsDBNull(dr["a11_8"])) nc.a11_8 = Convert.ToInt32(dr["a11_8"]); // a11_8
            if (Fileds.ContainsKey("a11_9") && !Convert.IsDBNull(dr["a11_9"])) nc.a11_9 = Convert.ToDouble(dr["a11_9"]); // a11_9
            if (Fileds.ContainsKey("a12_1") && !Convert.IsDBNull(dr["a12_1"])) nc.a12_1 = Convert.ToInt32(dr["a12_1"]); // a12_1
            if (Fileds.ContainsKey("a12_2") && !Convert.IsDBNull(dr["a12_2"])) nc.a12_2 = Convert.ToInt32(dr["a12_2"]); // a12_2
            if (Fileds.ContainsKey("a12_3") && !Convert.IsDBNull(dr["a12_3"])) nc.a12_3 = Convert.ToDouble(dr["a12_3"]); // a12_3
            if (Fileds.ContainsKey("a12_4") && !Convert.IsDBNull(dr["a12_4"])) nc.a12_4 = Convert.ToInt32(dr["a12_4"]); // a12_4
            if (Fileds.ContainsKey("a12_5") && !Convert.IsDBNull(dr["a12_5"])) nc.a12_5 = Convert.ToInt32(dr["a12_5"]); // a12_5
            if (Fileds.ContainsKey("a12_6") && !Convert.IsDBNull(dr["a12_6"])) nc.a12_6 = Convert.ToDouble(dr["a12_6"]); // a12_6
            if (Fileds.ContainsKey("a12_7") && !Convert.IsDBNull(dr["a12_7"])) nc.a12_7 = Convert.ToInt32(dr["a12_7"]); // a12_7
            if (Fileds.ContainsKey("a12_8") && !Convert.IsDBNull(dr["a12_8"])) nc.a12_8 = Convert.ToInt32(dr["a12_8"]); // a12_8
            if (Fileds.ContainsKey("a12_9") && !Convert.IsDBNull(dr["a12_9"])) nc.a12_9 = Convert.ToDouble(dr["a12_9"]); // a12_9
            if (Fileds.ContainsKey("a13_1") && !Convert.IsDBNull(dr["a13_1"])) nc.a13_1 = Convert.ToInt32(dr["a13_1"]); // a13_1
            if (Fileds.ContainsKey("a13_2") && !Convert.IsDBNull(dr["a13_2"])) nc.a13_2 = Convert.ToInt32(dr["a13_2"]); // a13_2
            if (Fileds.ContainsKey("a13_3") && !Convert.IsDBNull(dr["a13_3"])) nc.a13_3 = Convert.ToDouble(dr["a13_3"]); // a13_3
            if (Fileds.ContainsKey("a13_4") && !Convert.IsDBNull(dr["a13_4"])) nc.a13_4 = Convert.ToInt32(dr["a13_4"]); // a13_4
            if (Fileds.ContainsKey("a13_5") && !Convert.IsDBNull(dr["a13_5"])) nc.a13_5 = Convert.ToInt32(dr["a13_5"]); // a13_5
            if (Fileds.ContainsKey("a13_6") && !Convert.IsDBNull(dr["a13_6"])) nc.a13_6 = Convert.ToDouble(dr["a13_6"]); // a13_6
            if (Fileds.ContainsKey("a13_7") && !Convert.IsDBNull(dr["a13_7"])) nc.a13_7 = Convert.ToInt32(dr["a13_7"]); // a13_7
            if (Fileds.ContainsKey("a13_8") && !Convert.IsDBNull(dr["a13_8"])) nc.a13_8 = Convert.ToInt32(dr["a13_8"]); // a13_8
            if (Fileds.ContainsKey("a13_9") && !Convert.IsDBNull(dr["a13_9"])) nc.a13_9 = Convert.ToDouble(dr["a13_9"]); // a13_9
            if (Fileds.ContainsKey("a14_1") && !Convert.IsDBNull(dr["a14_1"])) nc.a14_1 = Convert.ToInt32(dr["a14_1"]); // a14_1
            if (Fileds.ContainsKey("a14_2") && !Convert.IsDBNull(dr["a14_2"])) nc.a14_2 = Convert.ToInt32(dr["a14_2"]); // a14_2
            if (Fileds.ContainsKey("a14_3") && !Convert.IsDBNull(dr["a14_3"])) nc.a14_3 = Convert.ToDouble(dr["a14_3"]); // a14_3
            if (Fileds.ContainsKey("a14_4") && !Convert.IsDBNull(dr["a14_4"])) nc.a14_4 = Convert.ToInt32(dr["a14_4"]); // a14_4
            if (Fileds.ContainsKey("a14_5") && !Convert.IsDBNull(dr["a14_5"])) nc.a14_5 = Convert.ToInt32(dr["a14_5"]); // a14_5
            if (Fileds.ContainsKey("a14_6") && !Convert.IsDBNull(dr["a14_6"])) nc.a14_6 = Convert.ToDouble(dr["a14_6"]); // a14_6
            if (Fileds.ContainsKey("a14_7") && !Convert.IsDBNull(dr["a14_7"])) nc.a14_7 = Convert.ToInt32(dr["a14_7"]); // a14_7
            if (Fileds.ContainsKey("a14_8") && !Convert.IsDBNull(dr["a14_8"])) nc.a14_8 = Convert.ToInt32(dr["a14_8"]); // a14_8
            if (Fileds.ContainsKey("a14_9") && !Convert.IsDBNull(dr["a14_9"])) nc.a14_9 = Convert.ToDouble(dr["a14_9"]); // a14_9
            if (Fileds.ContainsKey("a15_1") && !Convert.IsDBNull(dr["a15_1"])) nc.a15_1 = Convert.ToInt32(dr["a15_1"]); // a15_1
            if (Fileds.ContainsKey("a15_2") && !Convert.IsDBNull(dr["a15_2"])) nc.a15_2 = Convert.ToInt32(dr["a15_2"]); // a15_2
            if (Fileds.ContainsKey("a15_3") && !Convert.IsDBNull(dr["a15_3"])) nc.a15_3 = Convert.ToDouble(dr["a15_3"]); // a15_3
            if (Fileds.ContainsKey("a15_4") && !Convert.IsDBNull(dr["a15_4"])) nc.a15_4 = Convert.ToInt32(dr["a15_4"]); // a15_4
            if (Fileds.ContainsKey("a15_5") && !Convert.IsDBNull(dr["a15_5"])) nc.a15_5 = Convert.ToInt32(dr["a15_5"]); // a15_5
            if (Fileds.ContainsKey("a15_6") && !Convert.IsDBNull(dr["a15_6"])) nc.a15_6 = Convert.ToDouble(dr["a15_6"]); // a15_6
            if (Fileds.ContainsKey("a15_7") && !Convert.IsDBNull(dr["a15_7"])) nc.a15_7 = Convert.ToInt32(dr["a15_7"]); // a15_7
            if (Fileds.ContainsKey("a15_8") && !Convert.IsDBNull(dr["a15_8"])) nc.a15_8 = Convert.ToInt32(dr["a15_8"]); // a15_8
            if (Fileds.ContainsKey("a15_9") && !Convert.IsDBNull(dr["a15_9"])) nc.a15_9 = Convert.ToDouble(dr["a15_9"]); // a15_9
            if (Fileds.ContainsKey("a16_1") && !Convert.IsDBNull(dr["a16_1"])) nc.a16_1 = Convert.ToInt32(dr["a16_1"]); // a16_1
            if (Fileds.ContainsKey("a16_2") && !Convert.IsDBNull(dr["a16_2"])) nc.a16_2 = Convert.ToInt32(dr["a16_2"]); // a16_2
            if (Fileds.ContainsKey("a16_3") && !Convert.IsDBNull(dr["a16_3"])) nc.a16_3 = Convert.ToDouble(dr["a16_3"]); // a16_3
            if (Fileds.ContainsKey("a16_4") && !Convert.IsDBNull(dr["a16_4"])) nc.a16_4 = Convert.ToInt32(dr["a16_4"]); // a16_4
            if (Fileds.ContainsKey("a16_5") && !Convert.IsDBNull(dr["a16_5"])) nc.a16_5 = Convert.ToInt32(dr["a16_5"]); // a16_5
            if (Fileds.ContainsKey("a16_6") && !Convert.IsDBNull(dr["a16_6"])) nc.a16_6 = Convert.ToDouble(dr["a16_6"]); // a16_6
            if (Fileds.ContainsKey("a16_7") && !Convert.IsDBNull(dr["a16_7"])) nc.a16_7 = Convert.ToInt32(dr["a16_7"]); // a16_7
            if (Fileds.ContainsKey("a16_8") && !Convert.IsDBNull(dr["a16_8"])) nc.a16_8 = Convert.ToInt32(dr["a16_8"]); // a16_8
            if (Fileds.ContainsKey("a16_9") && !Convert.IsDBNull(dr["a16_9"])) nc.a16_9 = Convert.ToDouble(dr["a16_9"]); // a16_9
            if (Fileds.ContainsKey("a17_1") && !Convert.IsDBNull(dr["a17_1"])) nc.a17_1 = Convert.ToInt32(dr["a17_1"]); // a17_1
            if (Fileds.ContainsKey("a17_2") && !Convert.IsDBNull(dr["a17_2"])) nc.a17_2 = Convert.ToInt32(dr["a17_2"]); // a17_2
            if (Fileds.ContainsKey("a17_3") && !Convert.IsDBNull(dr["a17_3"])) nc.a17_3 = Convert.ToDouble(dr["a17_3"]); // a17_3
            if (Fileds.ContainsKey("a17_4") && !Convert.IsDBNull(dr["a17_4"])) nc.a17_4 = Convert.ToInt32(dr["a17_4"]); // a17_4
            if (Fileds.ContainsKey("a17_5") && !Convert.IsDBNull(dr["a17_5"])) nc.a17_5 = Convert.ToInt32(dr["a17_5"]); // a17_5
            if (Fileds.ContainsKey("a17_6") && !Convert.IsDBNull(dr["a17_6"])) nc.a17_6 = Convert.ToDouble(dr["a17_6"]); // a17_6
            if (Fileds.ContainsKey("a17_7") && !Convert.IsDBNull(dr["a17_7"])) nc.a17_7 = Convert.ToInt32(dr["a17_7"]); // a17_7
            if (Fileds.ContainsKey("a17_8") && !Convert.IsDBNull(dr["a17_8"])) nc.a17_8 = Convert.ToInt32(dr["a17_8"]); // a17_8
            if (Fileds.ContainsKey("a17_9") && !Convert.IsDBNull(dr["a17_9"])) nc.a17_9 = Convert.ToDouble(dr["a17_9"]); // a17_9
            if (Fileds.ContainsKey("a18_1") && !Convert.IsDBNull(dr["a18_1"])) nc.a18_1 = Convert.ToInt32(dr["a18_1"]); // a18_1
            if (Fileds.ContainsKey("a18_2") && !Convert.IsDBNull(dr["a18_2"])) nc.a18_2 = Convert.ToInt32(dr["a18_2"]); // a18_2
            if (Fileds.ContainsKey("a18_3") && !Convert.IsDBNull(dr["a18_3"])) nc.a18_3 = Convert.ToDouble(dr["a18_3"]); // a18_3
            if (Fileds.ContainsKey("a18_4") && !Convert.IsDBNull(dr["a18_4"])) nc.a18_4 = Convert.ToInt32(dr["a18_4"]); // a18_4
            if (Fileds.ContainsKey("a18_5") && !Convert.IsDBNull(dr["a18_5"])) nc.a18_5 = Convert.ToInt32(dr["a18_5"]); // a18_5
            if (Fileds.ContainsKey("a18_6") && !Convert.IsDBNull(dr["a18_6"])) nc.a18_6 = Convert.ToDouble(dr["a18_6"]); // a18_6
            if (Fileds.ContainsKey("a18_7") && !Convert.IsDBNull(dr["a18_7"])) nc.a18_7 = Convert.ToInt32(dr["a18_7"]); // a18_7
            if (Fileds.ContainsKey("a18_8") && !Convert.IsDBNull(dr["a18_8"])) nc.a18_8 = Convert.ToInt32(dr["a18_8"]); // a18_8
            if (Fileds.ContainsKey("a18_9") && !Convert.IsDBNull(dr["a18_9"])) nc.a18_9 = Convert.ToDouble(dr["a18_9"]); // a18_9
            if (Fileds.ContainsKey("a19_1") && !Convert.IsDBNull(dr["a19_1"])) nc.a19_1 = Convert.ToInt32(dr["a19_1"]); // a19_1
            if (Fileds.ContainsKey("a19_2") && !Convert.IsDBNull(dr["a19_2"])) nc.a19_2 = Convert.ToInt32(dr["a19_2"]); // a19_2
            if (Fileds.ContainsKey("a19_3") && !Convert.IsDBNull(dr["a19_3"])) nc.a19_3 = Convert.ToDouble(dr["a19_3"]); // a19_3
            if (Fileds.ContainsKey("a19_4") && !Convert.IsDBNull(dr["a19_4"])) nc.a19_4 = Convert.ToInt32(dr["a19_4"]); // a19_4
            if (Fileds.ContainsKey("a19_5") && !Convert.IsDBNull(dr["a19_5"])) nc.a19_5 = Convert.ToInt32(dr["a19_5"]); // a19_5
            if (Fileds.ContainsKey("a19_6") && !Convert.IsDBNull(dr["a19_6"])) nc.a19_6 = Convert.ToDouble(dr["a19_6"]); // a19_6
            if (Fileds.ContainsKey("a19_7") && !Convert.IsDBNull(dr["a19_7"])) nc.a19_7 = Convert.ToInt32(dr["a19_7"]); // a19_7
            if (Fileds.ContainsKey("a19_8") && !Convert.IsDBNull(dr["a19_8"])) nc.a19_8 = Convert.ToInt32(dr["a19_8"]); // a19_8
            if (Fileds.ContainsKey("a19_9") && !Convert.IsDBNull(dr["a19_9"])) nc.a19_9 = Convert.ToDouble(dr["a19_9"]); // a19_9
            if (Fileds.ContainsKey("a20_1") && !Convert.IsDBNull(dr["a20_1"])) nc.a20_1 = Convert.ToInt32(dr["a20_1"]); // a20_1
            if (Fileds.ContainsKey("a20_2") && !Convert.IsDBNull(dr["a20_2"])) nc.a20_2 = Convert.ToInt32(dr["a20_2"]); // a20_2
            if (Fileds.ContainsKey("a20_3") && !Convert.IsDBNull(dr["a20_3"])) nc.a20_3 = Convert.ToDouble(dr["a20_3"]); // a20_3
            if (Fileds.ContainsKey("a20_4") && !Convert.IsDBNull(dr["a20_4"])) nc.a20_4 = Convert.ToInt32(dr["a20_4"]); // a20_4
            if (Fileds.ContainsKey("a20_5") && !Convert.IsDBNull(dr["a20_5"])) nc.a20_5 = Convert.ToInt32(dr["a20_5"]); // a20_5
            if (Fileds.ContainsKey("a20_6") && !Convert.IsDBNull(dr["a20_6"])) nc.a20_6 = Convert.ToDouble(dr["a20_6"]); // a20_6
            if (Fileds.ContainsKey("a20_7") && !Convert.IsDBNull(dr["a20_7"])) nc.a20_7 = Convert.ToInt32(dr["a20_7"]); // a20_7
            if (Fileds.ContainsKey("a20_8") && !Convert.IsDBNull(dr["a20_8"])) nc.a20_8 = Convert.ToInt32(dr["a20_8"]); // a20_8
            if (Fileds.ContainsKey("a20_9") && !Convert.IsDBNull(dr["a20_9"])) nc.a20_9 = Convert.ToDouble(dr["a20_9"]); // a20_9
            if (Fileds.ContainsKey("a21_1") && !Convert.IsDBNull(dr["a21_1"])) nc.a21_1 = Convert.ToInt32(dr["a21_1"]); // a21_1
            if (Fileds.ContainsKey("a21_2") && !Convert.IsDBNull(dr["a21_2"])) nc.a21_2 = Convert.ToInt32(dr["a21_2"]); // a21_2
            if (Fileds.ContainsKey("a21_3") && !Convert.IsDBNull(dr["a21_3"])) nc.a21_3 = Convert.ToDouble(dr["a21_3"]); // a21_3
            if (Fileds.ContainsKey("a21_4") && !Convert.IsDBNull(dr["a21_4"])) nc.a21_4 = Convert.ToInt32(dr["a21_4"]); // a21_4
            if (Fileds.ContainsKey("a21_5") && !Convert.IsDBNull(dr["a21_5"])) nc.a21_5 = Convert.ToInt32(dr["a21_5"]); // a21_5
            if (Fileds.ContainsKey("a21_6") && !Convert.IsDBNull(dr["a21_6"])) nc.a21_6 = Convert.ToDouble(dr["a21_6"]); // a21_6
            if (Fileds.ContainsKey("a21_7") && !Convert.IsDBNull(dr["a21_7"])) nc.a21_7 = Convert.ToInt32(dr["a21_7"]); // a21_7
            if (Fileds.ContainsKey("a21_8") && !Convert.IsDBNull(dr["a21_8"])) nc.a21_8 = Convert.ToInt32(dr["a21_8"]); // a21_8
            if (Fileds.ContainsKey("a21_9") && !Convert.IsDBNull(dr["a21_9"])) nc.a21_9 = Convert.ToDouble(dr["a21_9"]); // a21_9
            if (Fileds.ContainsKey("dep") && !Convert.IsDBNull(dr["dep"])) nc.dep = Convert.ToString(dr["dep"]).Trim(); // dep
            if (Fileds.ContainsKey("tj") && !Convert.IsDBNull(dr["tj"])) nc.tj = Convert.ToString(dr["tj"]).Trim(); // tj
            if (Fileds.ContainsKey("phone") && !Convert.IsDBNull(dr["phone"])) nc.phone = Convert.ToString(dr["phone"]).Trim(); // phone
            if (Fileds.ContainsKey("tjDep") && !Convert.IsDBNull(dr["tjDep"])) nc.tjDep = Convert.ToInt32(dr["tjDep"]); // tjDep
            if (Fileds.ContainsKey("tjtime") && !Convert.IsDBNull(dr["tjtime"])) nc.tjtime = Convert.ToDateTime(dr["tjtime"]); // tjtime
            return nc;
        }
        #endregion

        #region "Mao(矛盾纠纷统计) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 MaoEntity (矛盾纠纷统计)
        /// </summary>
        /// <param name="fam">Mao实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 MaoInsertUpdateDelete(MaoEntity fam);

        /// <summary>
        /// 返回MaoEntity实体类的List对象 (矛盾纠纷统计)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>MaoEntity实体类的List对象(矛盾纠纷统计)</returns>
        public abstract List<MaoEntity> MaoList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为MaoEntity实体类 (矛盾纠纷统计)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>MaoEntity</returns>
        protected MaoEntity PopulateMaoEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            MaoEntity nc = new MaoEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("tjYear") && !Convert.IsDBNull(dr["tjYear"])) nc.tjYear = Convert.ToInt32(dr["tjYear"]); // tjYear
            if (Fileds.ContainsKey("tjSea") && !Convert.IsDBNull(dr["tjSea"])) nc.tjSea = Convert.ToInt32(dr["tjSea"]); // tjSea
            if (Fileds.ContainsKey("a11") && !Convert.IsDBNull(dr["a11"])) nc.a11 = Convert.ToInt32(dr["a11"]); // a11
            if (Fileds.ContainsKey("a12") && !Convert.IsDBNull(dr["a12"])) nc.a12 = Convert.ToInt32(dr["a12"]); // a12
            if (Fileds.ContainsKey("a21") && !Convert.IsDBNull(dr["a21"])) nc.a21 = Convert.ToInt32(dr["a21"]); // a21
            if (Fileds.ContainsKey("a22") && !Convert.IsDBNull(dr["a22"])) nc.a22 = Convert.ToInt32(dr["a22"]); // a22
            if (Fileds.ContainsKey("a31") && !Convert.IsDBNull(dr["a31"])) nc.a31 = Convert.ToInt32(dr["a31"]); // a31
            if (Fileds.ContainsKey("a32") && !Convert.IsDBNull(dr["a32"])) nc.a32 = Convert.ToInt32(dr["a32"]); // a32
            if (Fileds.ContainsKey("a41") && !Convert.IsDBNull(dr["a41"])) nc.a41 = Convert.ToInt32(dr["a41"]); // a41
            if (Fileds.ContainsKey("a42") && !Convert.IsDBNull(dr["a42"])) nc.a42 = Convert.ToInt32(dr["a42"]); // a42
            if (Fileds.ContainsKey("a51") && !Convert.IsDBNull(dr["a51"])) nc.a51 = Convert.ToInt32(dr["a51"]); // a51
            if (Fileds.ContainsKey("a52") && !Convert.IsDBNull(dr["a52"])) nc.a52 = Convert.ToInt32(dr["a52"]); // a52
            if (Fileds.ContainsKey("a61") && !Convert.IsDBNull(dr["a61"])) nc.a61 = Convert.ToInt32(dr["a61"]); // a61
            if (Fileds.ContainsKey("a62") && !Convert.IsDBNull(dr["a62"])) nc.a62 = Convert.ToInt32(dr["a62"]); // a62
            if (Fileds.ContainsKey("a71") && !Convert.IsDBNull(dr["a71"])) nc.a71 = Convert.ToInt32(dr["a71"]); // a71
            if (Fileds.ContainsKey("a72") && !Convert.IsDBNull(dr["a72"])) nc.a72 = Convert.ToInt32(dr["a72"]); // a72
            if (Fileds.ContainsKey("a81") && !Convert.IsDBNull(dr["a81"])) nc.a81 = Convert.ToInt32(dr["a81"]); // a81
            if (Fileds.ContainsKey("a82") && !Convert.IsDBNull(dr["a82"])) nc.a82 = Convert.ToInt32(dr["a82"]); // a82
            if (Fileds.ContainsKey("a91") && !Convert.IsDBNull(dr["a91"])) nc.a91 = Convert.ToInt32(dr["a91"]); // a91
            if (Fileds.ContainsKey("a92") && !Convert.IsDBNull(dr["a92"])) nc.a92 = Convert.ToInt32(dr["a92"]); // a92
            if (Fileds.ContainsKey("a101") && !Convert.IsDBNull(dr["a101"])) nc.a101 = Convert.ToInt32(dr["a101"]); // a101
            if (Fileds.ContainsKey("a102") && !Convert.IsDBNull(dr["a102"])) nc.a102 = Convert.ToInt32(dr["a102"]); // a102
            if (Fileds.ContainsKey("a111") && !Convert.IsDBNull(dr["a111"])) nc.a111 = Convert.ToInt32(dr["a111"]); // a111
            if (Fileds.ContainsKey("a112") && !Convert.IsDBNull(dr["a112"])) nc.a112 = Convert.ToInt32(dr["a112"]); // a112
            if (Fileds.ContainsKey("a121") && !Convert.IsDBNull(dr["a121"])) nc.a121 = Convert.ToInt32(dr["a121"]); // a121
            if (Fileds.ContainsKey("a122") && !Convert.IsDBNull(dr["a122"])) nc.a122 = Convert.ToInt32(dr["a122"]); // a122
            if (Fileds.ContainsKey("a131") && !Convert.IsDBNull(dr["a131"])) nc.a131 = Convert.ToInt32(dr["a131"]); // a131
            if (Fileds.ContainsKey("a132") && !Convert.IsDBNull(dr["a132"])) nc.a132 = Convert.ToInt32(dr["a132"]); // a132
            if (Fileds.ContainsKey("a133") && !Convert.IsDBNull(dr["a133"])) nc.a133 = Convert.ToInt32(dr["a133"]); // a133
            if (Fileds.ContainsKey("a141") && !Convert.IsDBNull(dr["a141"])) nc.a141 = Convert.ToInt32(dr["a141"]); // a141
            if (Fileds.ContainsKey("a142") && !Convert.IsDBNull(dr["a142"])) nc.a142 = Convert.ToInt32(dr["a142"]); // a142
            if (Fileds.ContainsKey("a15") && !Convert.IsDBNull(dr["a15"])) nc.a15 = Convert.ToInt32(dr["a15"]); // a15
            if (Fileds.ContainsKey("a16") && !Convert.IsDBNull(dr["a16"])) nc.a16 = Convert.ToInt32(dr["a16"]); // a16
            if (Fileds.ContainsKey("beizhu") && !Convert.IsDBNull(dr["beizhu"])) nc.beizhu = Convert.ToString(dr["beizhu"]).Trim(); // beizhu
            if (Fileds.ContainsKey("tjDep") && !Convert.IsDBNull(dr["tjDep"])) nc.tjDep = Convert.ToInt32(dr["tjDep"]); // tjDep
            if (Fileds.ContainsKey("AddDate") && !Convert.IsDBNull(dr["AddDate"])) nc.AddDate = Convert.ToDateTime(dr["AddDate"]); // AddDate
            return nc;
        }
        #endregion

        #region "TA(提案办理情况 ) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 TAEntity (提案办理情况 )
        /// </summary>
        /// <param name="fam">TA实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 TAInsertUpdateDelete(TAEntity fam);

        /// <summary>
        /// 返回TAEntity实体类的List对象 (提案办理情况 )
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>TAEntity实体类的List对象(提案办理情况 )</returns>
        public abstract List<TAEntity> TAList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为TAEntity实体类 (提案办理情况 )
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>TAEntity</returns>
        protected TAEntity PopulateTAEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            TAEntity nc = new TAEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("a11") && !Convert.IsDBNull(dr["a11"])) nc.a11 = Convert.ToInt32(dr["a11"]); // a11
            if (Fileds.ContainsKey("a12") && !Convert.IsDBNull(dr["a12"])) nc.a12 = Convert.ToInt32(dr["a12"]); // a12
            if (Fileds.ContainsKey("a21") && !Convert.IsDBNull(dr["a21"])) nc.a21 = Convert.ToInt32(dr["a21"]); // a21
            if (Fileds.ContainsKey("a22") && !Convert.IsDBNull(dr["a22"])) nc.a22 = Convert.ToInt32(dr["a22"]); // a22
            if (Fileds.ContainsKey("a31") && !Convert.IsDBNull(dr["a31"])) nc.a31 = Convert.ToInt32(dr["a31"]); // a31
            if (Fileds.ContainsKey("a32") && !Convert.IsDBNull(dr["a32"])) nc.a32 = Convert.ToInt32(dr["a32"]); // a32
            if (Fileds.ContainsKey("b11") && !Convert.IsDBNull(dr["b11"])) nc.b11 = Convert.ToInt32(dr["b11"]); // b11
            if (Fileds.ContainsKey("b12") && !Convert.IsDBNull(dr["b12"])) nc.b12 = Convert.ToInt32(dr["b12"]); // b12
            if (Fileds.ContainsKey("b21") && !Convert.IsDBNull(dr["b21"])) nc.b21 = Convert.ToInt32(dr["b21"]); // b21
            if (Fileds.ContainsKey("b22") && !Convert.IsDBNull(dr["b22"])) nc.b22 = Convert.ToInt32(dr["b22"]); // b22
            if (Fileds.ContainsKey("b31") && !Convert.IsDBNull(dr["b31"])) nc.b31 = Convert.ToInt32(dr["b31"]); // b31
            if (Fileds.ContainsKey("b32") && !Convert.IsDBNull(dr["b32"])) nc.b32 = Convert.ToInt32(dr["b32"]); // b32
            if (Fileds.ContainsKey("c11") && !Convert.IsDBNull(dr["c11"])) nc.c11 = Convert.ToInt32(dr["c11"]); // c11
            if (Fileds.ContainsKey("c12") && !Convert.IsDBNull(dr["c12"])) nc.c12 = Convert.ToInt32(dr["c12"]); // c12
            if (Fileds.ContainsKey("c21") && !Convert.IsDBNull(dr["c21"])) nc.c21 = Convert.ToInt32(dr["c21"]); // c21
            if (Fileds.ContainsKey("c22") && !Convert.IsDBNull(dr["c22"])) nc.c22 = Convert.ToInt32(dr["c22"]); // c22
            if (Fileds.ContainsKey("c31") && !Convert.IsDBNull(dr["c31"])) nc.c31 = Convert.ToInt32(dr["c31"]); // c31
            if (Fileds.ContainsKey("c32") && !Convert.IsDBNull(dr["c32"])) nc.c32 = Convert.ToInt32(dr["c32"]); // c32
            if (Fileds.ContainsKey("d11") && !Convert.IsDBNull(dr["d11"])) nc.d11 = Convert.ToInt32(dr["d11"]); // d11
            if (Fileds.ContainsKey("d12") && !Convert.IsDBNull(dr["d12"])) nc.d12 = Convert.ToInt32(dr["d12"]); // d12
            if (Fileds.ContainsKey("d21") && !Convert.IsDBNull(dr["d21"])) nc.d21 = Convert.ToInt32(dr["d21"]); // d21
            if (Fileds.ContainsKey("d22") && !Convert.IsDBNull(dr["d22"])) nc.d22 = Convert.ToInt32(dr["d22"]); // d22
            if (Fileds.ContainsKey("d31") && !Convert.IsDBNull(dr["d31"])) nc.d31 = Convert.ToInt32(dr["d31"]); // d31
            if (Fileds.ContainsKey("d32") && !Convert.IsDBNull(dr["d32"])) nc.d32 = Convert.ToInt32(dr["d32"]); // d32
            if (Fileds.ContainsKey("d41") && !Convert.IsDBNull(dr["d41"])) nc.d41 = Convert.ToInt32(dr["d41"]); // d41
            if (Fileds.ContainsKey("d42") && !Convert.IsDBNull(dr["d42"])) nc.d42 = Convert.ToInt32(dr["d42"]); // d42
            if (Fileds.ContainsKey("d51") && !Convert.IsDBNull(dr["d51"])) nc.d51 = Convert.ToInt32(dr["d51"]); // d51
            if (Fileds.ContainsKey("d52") && !Convert.IsDBNull(dr["d52"])) nc.d52 = Convert.ToInt32(dr["d52"]); // d52
            if (Fileds.ContainsKey("e11") && !Convert.IsDBNull(dr["e11"])) nc.e11 = Convert.ToInt32(dr["e11"]); // e11
            if (Fileds.ContainsKey("e12") && !Convert.IsDBNull(dr["e12"])) nc.e12 = Convert.ToInt32(dr["e12"]); // e12
            if (Fileds.ContainsKey("e21") && !Convert.IsDBNull(dr["e21"])) nc.e21 = Convert.ToInt32(dr["e21"]); // e21
            if (Fileds.ContainsKey("e22") && !Convert.IsDBNull(dr["e22"])) nc.e22 = Convert.ToInt32(dr["e22"]); // e22
            if (Fileds.ContainsKey("e31") && !Convert.IsDBNull(dr["e31"])) nc.e31 = Convert.ToInt32(dr["e31"]); // e31
            if (Fileds.ContainsKey("e32") && !Convert.IsDBNull(dr["e32"])) nc.e32 = Convert.ToInt32(dr["e32"]); // e32
            if (Fileds.ContainsKey("f11") && !Convert.IsDBNull(dr["f11"])) nc.f11 = Convert.ToInt32(dr["f11"]); // f11
            if (Fileds.ContainsKey("f12") && !Convert.IsDBNull(dr["f12"])) nc.f12 = Convert.ToInt32(dr["f12"]); // f12
            if (Fileds.ContainsKey("j11") && !Convert.IsDBNull(dr["j11"])) nc.j11 = Convert.ToInt32(dr["j11"]); // j11
            if (Fileds.ContainsKey("j12") && !Convert.IsDBNull(dr["j12"])) nc.j12 = Convert.ToInt32(dr["j12"]); // j12
            if (Fileds.ContainsKey("h11") && !Convert.IsDBNull(dr["h11"])) nc.h11 = Convert.ToInt32(dr["h11"]); // h11
            if (Fileds.ContainsKey("h12") && !Convert.IsDBNull(dr["h12"])) nc.h12 = Convert.ToInt32(dr["h12"]); // h12
            if (Fileds.ContainsKey("h21") && !Convert.IsDBNull(dr["h21"])) nc.h21 = Convert.ToInt32(dr["h21"]); // h21
            if (Fileds.ContainsKey("h22") && !Convert.IsDBNull(dr["h22"])) nc.h22 = Convert.ToInt32(dr["h22"]); // h22
            if (Fileds.ContainsKey("dep") && !Convert.IsDBNull(dr["dep"])) nc.dep = Convert.ToString(dr["dep"]).Trim(); // dep
            if (Fileds.ContainsKey("zhuguan") && !Convert.IsDBNull(dr["zhuguan"])) nc.zhuguan = Convert.ToString(dr["zhuguan"]).Trim(); // zhuguan
            if (Fileds.ContainsKey("tj") && !Convert.IsDBNull(dr["tj"])) nc.tj = Convert.ToString(dr["tj"]).Trim(); // tj
            if (Fileds.ContainsKey("tjdep") && !Convert.IsDBNull(dr["tjdep"])) nc.tjdep = Convert.ToString(dr["tjdep"]).Trim(); // tjdep
            if (Fileds.ContainsKey("tjtime") && !Convert.IsDBNull(dr["tjtime"])) nc.tjtime = Convert.ToDateTime(dr["tjtime"]); // tjtime
            return nc;
        }
        #endregion



        #region "XF(环境信访数据统计) - DataProvider"

        /// <summary>
        /// 新增/删除/修改 XFEntity (环境信访数据统计)
        /// </summary>
        /// <param name="fam">XF实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 XFInsertUpdateDelete(XFEntity fam);

        /// <summary>
        /// 返回XFEntity实体类的List对象 (环境信访数据统计)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>XFEntity实体类的List对象(环境信访数据统计)</returns>
        public abstract List<XFEntity> XFList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为XFEntity实体类 (环境信访数据统计)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>XFEntity</returns>
        protected XFEntity PopulateXFEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            XFEntity nc = new XFEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("tjYear") && !Convert.IsDBNull(dr["tjYear"])) nc.tjYear = Convert.ToInt32(dr["tjYear"]); // tjYear
            if (Fileds.ContainsKey("tjMonth") && !Convert.IsDBNull(dr["tjMonth"])) nc.tjMonth = Convert.ToInt32(dr["tjMonth"]); // tjMonth
            if (Fileds.ContainsKey("a1") && !Convert.IsDBNull(dr["a1"])) nc.a1 = Convert.ToInt32(dr["a1"]); // a1
            if (Fileds.ContainsKey("a2") && !Convert.IsDBNull(dr["a2"])) nc.a2 = Convert.ToInt32(dr["a2"]); // a2
            if (Fileds.ContainsKey("a3") && !Convert.IsDBNull(dr["a3"])) nc.a3 = Convert.ToInt32(dr["a3"]); // a3
            if (Fileds.ContainsKey("a4") && !Convert.IsDBNull(dr["a4"])) nc.a4 = Convert.ToInt32(dr["a4"]); // a4
            if (Fileds.ContainsKey("a5") && !Convert.IsDBNull(dr["a5"])) nc.a5 = Convert.ToInt32(dr["a5"]); // a5
            if (Fileds.ContainsKey("a6") && !Convert.IsDBNull(dr["a6"])) nc.a6 = Convert.ToInt32(dr["a6"]); // a6
            if (Fileds.ContainsKey("a7") && !Convert.IsDBNull(dr["a7"])) nc.a7 = Convert.ToInt32(dr["a7"]); // a7
            if (Fileds.ContainsKey("a8") && !Convert.IsDBNull(dr["a8"])) nc.a8 = Convert.ToInt32(dr["a8"]); // a8
            if (Fileds.ContainsKey("a9") && !Convert.IsDBNull(dr["a9"])) nc.a9 = Convert.ToInt32(dr["a9"]); // a9
            if (Fileds.ContainsKey("a10") && !Convert.IsDBNull(dr["a10"])) nc.a10 = Convert.ToInt32(dr["a10"]); // a10
            if (Fileds.ContainsKey("a11") && !Convert.IsDBNull(dr["a11"])) nc.a11 = Convert.ToInt32(dr["a11"]); // a11
            if (Fileds.ContainsKey("a12") && !Convert.IsDBNull(dr["a12"])) nc.a12 = Convert.ToInt32(dr["a12"]); // a12
            if (Fileds.ContainsKey("tbr") && !Convert.IsDBNull(dr["tbr"])) nc.tbr = Convert.ToString(dr["tbr"]).Trim(); // tbr
            if (Fileds.ContainsKey("phone") && !Convert.IsDBNull(dr["phone"])) nc.phone = Convert.ToString(dr["phone"]).Trim(); // phone
            if (Fileds.ContainsKey("tjdep") && !Convert.IsDBNull(dr["tjdep"])) nc.tjdep = Convert.ToInt32(dr["tjdep"]); // tjdep
            if (Fileds.ContainsKey("tjTime") && !Convert.IsDBNull(dr["tjTime"])) nc.tjTime = Convert.ToDateTime(dr["tjTime"]); // tjTime
            return nc;
        }
        #endregion
        #region "T_TouSu(**办理) - DataProvider"
 
        /// <summary>
        /// 新增/删除/修改 T_TouSuEntity (**办理)
        /// </summary>
        /// <param name="fam">T_TouSu实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 T_TouSuInsertUpdateDelete(T_TouSuEntity fam);

        /// <summary>
        /// 返回T_TouSuEntity实体类的List对象 (**办理)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>T_TouSuEntity实体类的List对象(**办理)</returns>
        public abstract List<T_TouSuEntity> T_TouSuList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为T_TouSuEntity实体类 (**办理)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>T_TouSuEntity</returns>
        protected T_TouSuEntity PopulateT_TouSuEntity(IDataReader dr,Dictionary<string,string> Fileds)
        {
            T_TouSuEntity nc = new T_TouSuEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("Type") && !Convert.IsDBNull(dr["Type"])) nc.Type = Convert.ToString(dr["Type"]).Trim(); // 类型
            if (Fileds.ContainsKey("TID") && !Convert.IsDBNull(dr["TID"])) nc.TID = Convert.ToString(dr["TID"]).Trim(); // 编号
            if (Fileds.ContainsKey("ALaiyuan") && !Convert.IsDBNull(dr["ALaiyuan"])) nc.ALaiyuan = Convert.ToString(dr["ALaiyuan"]).Trim(); // 来源
            if (Fileds.ContainsKey("AzhuanbanID") && !Convert.IsDBNull(dr["AzhuanbanID"])) nc.AzhuanbanID = Convert.ToString(dr["AzhuanbanID"]).Trim(); // 收到转办单编号
            if (Fileds.ContainsKey("AzhuanfangTime") && !Convert.IsDBNull(dr["AzhuanfangTime"])) nc.AzhuanfangTime = Convert.ToDateTime(dr["AzhuanfangTime"]); // 收到转办单时间
            if (Fileds.ContainsKey("ALiFangname") && !Convert.IsDBNull(dr["ALiFangname"])) nc.ALiFangname = Convert.ToString(dr["ALiFangname"]).Trim(); // 姓名
            if (Fileds.ContainsKey("ALaifangTime") && !Convert.IsDBNull(dr["ALaifangTime"])) nc.ALaifangTime = Convert.ToDateTime(dr["ALaifangTime"]); // 时间
            if (Fileds.ContainsKey("AID") && !Convert.IsDBNull(dr["AID"])) nc.AID = Convert.ToString(dr["AID"]).Trim(); // 身份证号码或其他证件号
            if (Fileds.ContainsKey("APhone") && !Convert.IsDBNull(dr["APhone"])) nc.APhone = Convert.ToString(dr["APhone"]).Trim(); //  联系电话
            if (Fileds.ContainsKey("AlaifangGroup") && !Convert.IsDBNull(dr["AlaifangGroup"])) nc.AlaifangGroup = Convert.ToString(dr["AlaifangGroup"]).Trim(); // 来访单位
            if (Fileds.ContainsKey("Alaifangzhuzhi") && !Convert.IsDBNull(dr["Alaifangzhuzhi"])) nc.Alaifangzhuzhi = Convert.ToString(dr["Alaifangzhuzhi"]).Trim(); // 来访人住址
            if (Fileds.ContainsKey("Alaifangpostcode") && !Convert.IsDBNull(dr["Alaifangpostcode"])) nc.Alaifangpostcode = Convert.ToString(dr["Alaifangpostcode"]).Trim(); //   来访人单位或住址邮政编码
            if (Fileds.ContainsKey("Abeitousudanw") && !Convert.IsDBNull(dr["Abeitousudanw"])) nc.Abeitousudanw = Convert.ToString(dr["Abeitousudanw"]).Trim(); // 被投诉单位地址
            if (Fileds.ContainsKey("AbeitousuName") && !Convert.IsDBNull(dr["AbeitousuName"])) nc.AbeitousuName = Convert.ToString(dr["AbeitousuName"]).Trim(); // 被投诉单位名称以及法人代表
            if (Fileds.ContainsKey("Afanyingwenti") && !Convert.IsDBNull(dr["Afanyingwenti"])) nc.Afanyingwenti = Convert.ToString(dr["Afanyingwenti"]).Trim(); // 反映的主要污染问题是什么？水、气、噪声、振动、电磁辐射污染还是赔偿？
            if (Fileds.ContainsKey("AdiyiciTime") && !Convert.IsDBNull(dr["AdiyiciTime"])) nc.AdiyiciTime = Convert.ToDateTime(dr["AdiyiciTime"]); // 第一次污染问题发生时间
            if (Fileds.ContainsKey("Asunshi") && !Convert.IsDBNull(dr["Asunshi"])) nc.Asunshi = Convert.ToString(dr["Asunshi"]).Trim(); // 损失情况
            if (Fileds.ContainsKey("Azhinengbumen") && !Convert.IsDBNull(dr["Azhinengbumen"])) nc.Azhinengbumen = Convert.ToString(dr["Azhinengbumen"]).Trim(); // 哪个职能部门做的损失鉴定
            if (Fileds.ContainsKey("ATimeAndGroup") && !Convert.IsDBNull(dr["ATimeAndGroup"])) nc.ATimeAndGroup = Convert.ToString(dr["ATimeAndGroup"]).Trim(); // 第一次、在什么时间，向哪个环保部门反映的
            if (Fileds.ContainsKey("AfanyingTime") && !Convert.IsDBNull(dr["AfanyingTime"])) nc.AfanyingTime = Convert.ToDateTime(dr["AfanyingTime"]); // 反映的时间
            if (Fileds.ContainsKey("Achuliqingkuang") && !Convert.IsDBNull(dr["Achuliqingkuang"])) nc.Achuliqingkuang = Convert.ToString(dr["Achuliqingkuang"]).Trim(); // 县（区、市）处理答复情况
            if (Fileds.ContainsKey("ADafu") && !Convert.IsDBNull(dr["ADafu"])) nc.ADafu = Convert.ToString(dr["ADafu"]).Trim(); // 是否给答复意见书？答复意见书的内容
            if (Fileds.ContainsKey("AShenqingfucha") && !Convert.IsDBNull(dr["AShenqingfucha"])) nc.AShenqingfucha = Convert.ToString(dr["AShenqingfucha"]).Trim(); // 是否向市环保部门反映（申请复查                         
            if (Fileds.ContainsKey("AfuchaTime") && !Convert.IsDBNull(dr["AfuchaTime"])) nc.AfuchaTime = Convert.ToDateTime(dr["AfuchaTime"]); //  申请复查时间
            if (Fileds.ContainsKey("AShiyijian") && !Convert.IsDBNull(dr["AShiyijian"])) nc.AShiyijian = Convert.ToString(dr["AShiyijian"]).Trim(); // 市环保部门的答复和处理意见（复查意见）：
   
            if (Fileds.ContainsKey("Axinfangbanyijian") && !Convert.IsDBNull(dr["Axinfangbanyijian"])) nc.Axinfangbanyijian = Convert.ToString(dr["Axinfangbanyijian"]).Trim(); // 信访办受理意见
            if (Fileds.ContainsKey("AlingdaoYijian") && !Convert.IsDBNull(dr["AlingdaoYijian"])) nc.AlingdaoYijian = Convert.ToString(dr["AlingdaoYijian"]).Trim(); // 领导批示意见
            if (Fileds.ContainsKey("Azhuanchu") && !Convert.IsDBNull(dr["Azhuanchu"])) nc.Azhuanchu = Convert.ToString(dr["Azhuanchu"]).Trim(); // 转出去向
            if (Fileds.ContainsKey("AzhuanchuTime") && !Convert.IsDBNull(dr["AzhuanchuTime"])) nc.AzhuanchuTime = Convert.ToDateTime(dr["AzhuanchuTime"]); //   转出时间
            if (Fileds.ContainsKey("AyaoqiuTime") && !Convert.IsDBNull(dr["AyaoqiuTime"])) nc.AyaoqiuTime = Convert.ToString(dr["AyaoqiuTime"]).Trim(); // 要求办结上报时间
            if (Fileds.ContainsKey("Ajieguo") && !Convert.IsDBNull(dr["Ajieguo"])) nc.Ajieguo = Convert.ToString(dr["Ajieguo"]).Trim(); // 办理结果
            if (Fileds.ContainsKey("Ajiluren") && !Convert.IsDBNull(dr["Ajiluren"])) nc.Ajiluren = Convert.ToString(dr["Ajiluren"]).Trim(); // 记录人
            if (Fileds.ContainsKey("AjilushiTime") && !Convert.IsDBNull(dr["AjilushiTime"])) nc.AjilushiTime = Convert.ToDateTime(dr["AjilushiTime"]); // 记录时间
            if (Fileds.ContainsKey("Afujian") && !Convert.IsDBNull(dr["Afujian"])) nc.Afujian = Convert.ToString(dr["Afujian"]).Trim(); // 附件
            if (Fileds.ContainsKey("BWentiType") && !Convert.IsDBNull(dr["BWentiType"])) nc.BWentiType = Convert.ToString(dr["BWentiType"]).Trim(); // 反映问题类型
            if (Fileds.ContainsKey("BXianCon") && !Convert.IsDBNull(dr["BXianCon"])) nc.BXianCon = Convert.ToString(dr["BXianCon"]).Trim(); // 县区办理结果
            if (Fileds.ContainsKey("BXinfang") && !Convert.IsDBNull(dr["BXinfang"])) nc.BXinfang = Convert.ToString(dr["BXinfang"]).Trim(); // 信访办受理意见
            if (Fileds.ContainsKey("BLingdao") && !Convert.IsDBNull(dr["BLingdao"])) nc.BLingdao = Convert.ToString(dr["BLingdao"]).Trim(); // 领导批示意见
            if (Fileds.ContainsKey("BSumDay") && !Convert.IsDBNull(dr["BSumDay"])) nc.BSumDay = Convert.ToString(dr["BSumDay"]).Trim(); // 要求办结上报时间
            if (Fileds.ContainsKey("BEndDate") && !Convert.IsDBNull(dr["BEndDate"])) nc.BEndDate = Convert.ToDateTime(dr["BEndDate"]); // 要求时间
            if (Fileds.ContainsKey("BChuliGroup") && !Convert.IsDBNull(dr["BChuliGroup"])) nc.BChuliGroup = Convert.ToInt32(dr["BChuliGroup"]); // 处理单位
            if (Fileds.ContainsKey("BChaoSong") && !Convert.IsDBNull(dr["BChaoSong"])) nc.BChaoSong = Convert.ToString(dr["BChaoSong"]).Trim(); // 抄送单位
            if (Fileds.ContainsKey("BXieban") && !Convert.IsDBNull(dr["BXieban"])) nc.BXieban = Convert.ToString(dr["BXieban"]).Trim(); // 协办单位
            if (Fileds.ContainsKey("BIF") && !Convert.IsDBNull(dr["BIF"])) nc.BIF = Convert.ToString(dr["BIF"]).Trim(); // 是否办结
            if (Fileds.ContainsKey("BChuliDate") && !Convert.IsDBNull(dr["BChuliDate"])) nc.BChuliDate = Convert.ToDateTime(dr["BChuliDate"]); // 处理时间
            if (Fileds.ContainsKey("zhuangtai") && !Convert.IsDBNull(dr["zhuangtai"])) nc.zhuangtai = Convert.ToString(dr["zhuangtai"]).Trim(); // 办理状态
            if (Fileds.ContainsKey("toLingDao") && !Convert.IsDBNull(dr["toLingDao"])) nc.toLingDao = Convert.ToInt32(dr["toLingDao"]); // toLingDao
            return nc;
        }
        #endregion

        #region "T_Web(网上投诉) - DataProvider"
 
        /// <summary>
        /// 新增/删除/修改 T_WebEntity (网上投诉)
        /// </summary>
        /// <param name="fam">T_Web实体类</param>
        /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
        public abstract Int32 T_WebInsertUpdateDelete(T_WebEntity fam);

        /// <summary>
        /// 返回T_WebEntity实体类的List对象 (网上投诉)
        /// </summary>
        /// <param name="qp">查询类(非安全函数,传入参数请进行Sql字符串过滤)</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>T_WebEntity实体类的List对象(网上投诉)</returns>
        public abstract List<T_WebEntity> T_WebList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为T_WebEntity实体类 (网上投诉)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>T_WebEntity</returns>
        protected T_WebEntity PopulateT_WebEntity(IDataReader dr,Dictionary<string,string> Fileds)
        {
            T_WebEntity nc = new T_WebEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
            if (Fileds.ContainsKey("TID") && !Convert.IsDBNull(dr["TID"])) nc.TID = Convert.ToString(dr["TID"]).Trim(); // 投诉编号
            if (Fileds.ContainsKey("TPassword") && !Convert.IsDBNull(dr["TPassword"])) nc.TPassword = Convert.ToString(dr["TPassword"]).Trim(); // 密码
            if (Fileds.ContainsKey("TName") && !Convert.IsDBNull(dr["TName"])) nc.TName = Convert.ToString(dr["TName"]).Trim(); // 投诉人姓名
            if (Fileds.ContainsKey("TNo") && !Convert.IsDBNull(dr["TNo"])) nc.TNo = Convert.ToString(dr["TNo"]).Trim(); // 投诉人证件号码
            if (Fileds.ContainsKey("TPhone") && !Convert.IsDBNull(dr["TPhone"])) nc.TPhone = Convert.ToString(dr["TPhone"]).Trim(); // 联系电话
            if (Fileds.ContainsKey("TGroup") && !Convert.IsDBNull(dr["TGroup"])) nc.TGroup = Convert.ToString(dr["TGroup"]).Trim(); // 投诉人单位或住址
            if (Fileds.ContainsKey("TBGName") && !Convert.IsDBNull(dr["TBGName"])) nc.TBGName = Convert.ToString(dr["TBGName"]).Trim(); // 被投诉单位名称
            if (Fileds.ContainsKey("TBAddress") && !Convert.IsDBNull(dr["TBAddress"])) nc.TBAddress = Convert.ToString(dr["TBAddress"]).Trim(); // 被投诉单位地址
            if (Fileds.ContainsKey("TTtle") && !Convert.IsDBNull(dr["TTtle"])) nc.TTtle = Convert.ToString(dr["TTtle"]).Trim(); // 投诉标题
            if (Fileds.ContainsKey("TContent") && !Convert.IsDBNull(dr["TContent"])) nc.TContent = Convert.ToString(dr["TContent"]).Trim(); // 投诉内容
            if (Fileds.ContainsKey("TTime") && !Convert.IsDBNull(dr["TTime"])) nc.TTime = Convert.ToDateTime(dr["TTime"]); // 投诉时间
            if (Fileds.ContainsKey("XType") && !Convert.IsDBNull(dr["XType"])) nc.XType = Convert.ToString(dr["XType"]).Trim(); // 反映问题类型
            if (Fileds.ContainsKey("XXian") && !Convert.IsDBNull(dr["XXian"])) nc.XXian = Convert.ToString(dr["XXian"]).Trim(); // 县区或科室办理结果
            if (Fileds.ContainsKey("XShi") && !Convert.IsDBNull(dr["XShi"])) nc.XShi = Convert.ToString(dr["XShi"]).Trim(); // 信访办受理意见
            if (Fileds.ContainsKey("XLingDao") && !Convert.IsDBNull(dr["XLingDao"])) nc.XLingDao = Convert.ToString(dr["XLingDao"]).Trim(); // 领导批示意见
            if (Fileds.ContainsKey("XSumDay") && !Convert.IsDBNull(dr["XSumDay"])) nc.XSumDay = Convert.ToInt32(dr["XSumDay"]); // 要求办结上报时间
            if (Fileds.ContainsKey("XEndDate") && !Convert.IsDBNull(dr["XEndDate"])) nc.XEndDate = Convert.ToDateTime(dr["XEndDate"]); // 时间至
            if (Fileds.ContainsKey("XCLDW") && !Convert.IsDBNull(dr["XCLDW"])) nc.XCLDW = Convert.ToInt32(dr["XCLDW"]); // 处理单位
            if (Fileds.ContainsKey("XCSDW") && !Convert.IsDBNull(dr["XCSDW"])) nc.XCSDW = Convert.ToString(dr["XCSDW"]).Trim(); // XCSDW
            if (Fileds.ContainsKey("XXieBan") && !Convert.IsDBNull(dr["XXieBan"])) nc.XXieBan = Convert.ToString(dr["XXieBan"]).Trim(); // 协办单位
            if (Fileds.ContainsKey("XIF") && !Convert.IsDBNull(dr["XIF"])) nc.XIF = Convert.ToString(dr["XIF"]).Trim(); // 是否办结
            if (Fileds.ContainsKey("Pevel") && !Convert.IsDBNull(dr["Pevel"])) nc.Pevel = Convert.ToInt32(dr["Pevel"]); // 满意度
            if (Fileds.ContainsKey("PContent") && !Convert.IsDBNull(dr["PContent"])) nc.PContent = Convert.ToString(dr["PContent"]).Trim(); // 评议内容
            if (Fileds.ContainsKey("PTime") && !Convert.IsDBNull(dr["PTime"])) nc.PTime = Convert.ToDateTime(dr["PTime"]); // 评议时间
            if (Fileds.ContainsKey("XTime") && !Convert.IsDBNull(dr["XTime"])) nc.XTime = Convert.ToDateTime(dr["XTime"]); // 批示时间
            if (Fileds.ContainsKey("zhuangtai") && !Convert.IsDBNull(dr["zhuangtai"])) nc.zhuangtai = Convert.ToString(dr["zhuangtai"]).Trim(); // 状态
            if (Fileds.ContainsKey("toLingDao") && !Convert.IsDBNull(dr["toLingDao"])) nc.toLingDao = Convert.ToInt32(dr["toLingDao"]); // toLingDao
            return nc;
        }
        #endregion
        
        #region "获取表中字段值"
        /// <summary>
        /// 获取表中字段值(非安全函数,传入参数请进行Sql字符串过滤)
        /// </summary>
        /// <param name="table_name">表名</param>
        /// <param name="table_fileds">字段</param>
        /// <param name="where_fileds">查询条件字段</param>
        /// <param name="where_value">查询值</param>
        /// <returns></returns>
        public abstract string get_table_fileds(string table_name, string table_fileds, string where_fileds, string where_value);
        public abstract string get_table_fileds2(string table_name, string table_fileds, string where_fileds, string where_value, string where_fileds2, string where_value2, string where_fileds3, string where_value3, string where_fileds4, string where_value4);
       
        public abstract string get_table_fileds3(string table_name, string table_fileds, string where_fileds, string where_value, string where_fileds2, string where_value2, string where_fileds3, string where_value3, string where_fileds4, string where_value4);
        #endregion

        #region "列新表中字段值"
        /// <summary>
        /// 更新表中字段值(非安全函数,传入参数请进行Sql字符串过滤)
        /// </summary>
        /// <param name="Table">表名</param>
        /// <param name="Table_FiledsValue">需要更新值(不用带Set)</param>
        /// <param name="Wheres">更新条件(不用带Where)</param>
        /// <returns></returns>
        public abstract int Update_Table_Fileds(string Table, string Table_FiledsValue, string Wheres);
        #endregion
    }
}
